Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Remote Connect
June 17, 2005, 3:51 pm
rate this thread
I've installed MySQL 4.1.12 on my server, I can connect from the local
machine with navicat, but
not from a remote machine. I checked with 'nedstat' and there is something
listening on port 3306.
I have tried several users and settings. What i want is to set a user name
(:support) and that this user
can connect remotely with navicat to the mysql server.
How would I do this? Or what am I doing wrong?
Thanks for any help!
(Just a note, I before had mysql 3.xx installed and I could without
anyproblems connect to that remotely)
Posted by news://news.nb.nu
Re: Remote Connect
So what error do you get when you try? Something on the line of
You need to grant privileges for a remote user to connect, probably
for EVERY machine he wants to connect from. This is not done by
default (for very good reason). Note that if you are using PHP
or some other web-based access, the connection to mysql is made
from the web server, not the machine with the user's browser on it.
Check out the grant table setup you had then.
There is also a problem that NEW-style passwords (this is the
default) set on a NEW-style server can't be used on an OLD-style
client. I don't remember the dividing point, but 4.1.12 is new and
3.23.* is old.
Gordon L. Burditt
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum