MYSQL server in linux, client on Windows connection problem

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
Sam [ Mi, 26 Juli 2006 00:34 ] [ ID #1404021 ]

Re: MYSQL server in linux, client on Windows connection problem

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.
Bill Karwin [ So, 30 Juli 2006 02:54 ] [ ID #1410414 ]
Datenbanken » mailing.database.mysql » MYSQL server in linux, client on Windows connection problem

Vorheriges Thema: enable pooling on my sql
Nächstes Thema: Scheduale a stored procedure