MYSQL server in linux, client on Windows connection problem
am 26.07.2006 00:34:00 von 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
Re: MYSQL server in linux, client on Windows connection problem
am 30.07.2006 02:54:17 von Bill Karwin
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/en/can-not-connect-to-se rver.html
Regards,
Bill K.