472,125 Members | 1,575 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

MYSQL server in linux, client on Windows connection problem

Sam
Hi Everybody,
I have a SQL server on a Linux Fedora machine and I try to use a GUI to
connect to database
I used different GUI like "Toad for MySQL"
in connection page I put Linux IP address as "Server host" and
username/password I keep getting error:
Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061)

My question is: Do I need a client installation or configuration on Windows
machine?
What could be the problem?

Thanks you in advance - Sam
Jul 25 '06 #1
1 10779
Sam wrote:
Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061)

My question is: Do I need a client installation or configuration on Windows
machine?
You already have the client installed on your Windows machine. MySQL
error messages in the 2000's are client errors. It's using the client
successfully, but it is not able to connect to the server host.

Common causes of this error include:
- Firewall on server blocks incoming requests.
- Firewall on client blocks outgoing requests.
- MySQL Server on server host is not running.
- MySQL Server on server host is running, but has "skip-networking" or
"bind-address=127.0.0.1" options enabled in its my.cnf file.

Also see
http://dev.mysql.com/doc/refman/5.0/...to-server.html

Regards,
Bill K.
Jul 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Mike MacSween | last post: by
reply views Thread by Mike Chirico | last post: by
1 post views Thread by Jason Wilson | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.