MySQL Server Forum - Remote Connect

Author

Remote Connect

Steven

2005-06-17, 7:23 am

Hi All,

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

Steven

2005-06-17, 7:23 am

O yea, I can telnet to port 3306 and I see the MySQL version followed by
some binary data. So connecting
on that port is not the problem

--
Posted by news://news.nb.nu

Good Man

2005-06-17, 9:23 am

"Steven" <santa@emailme.nu> wrote in news:42b2b260@news.nb.nu:

> O yea, I can telnet to port 3306 and I see the MySQL version followed by
> some binary data. So connecting
> on that port is not the problem

there are probably user pemissions within your MySQL users table that
prevent any connections except 'localhost' for the user you are trying to
log in as...

Gordon Burditt

2005-06-17, 1:23 pm

>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.

So what error do you get when you try? Something on the line of
'permission denied'?

>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?

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.

>(Just a note, I before had mysql 3.xx installed and I could without
>anyproblems connect to that remotely)

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

Sponsored Links