By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,665 Members | 1,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,665 IT Pros & Developers. It's quick & easy.

Remote Connect

P: n/a
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
Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jul 23 '05 #2

P: n/a
"Steven" <sa***@emailme.nu> wrote in news:42******@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...
Jul 23 '05 #3

P: n/a
>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
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.