Link to home
Start Free TrialLog in
Avatar of ric_m
ric_m

asked on

MySql Connection Failed: 2003 Can't connect to MySQL Server on '192.168.0.1' (10054)

Using MySQL-Front on Win XP machine to connect to MySQL on Fedora Core5 box on 192.168.0.xxx network.

Hostname: 192.168.0.1
user: root
Password: ***

After the timeout  I get:
MySql Connection Failed: 2003 Can't connect to MySQL Server on '192.168.0.1' (10054) <== not sure what 10054 is

To fill-in some detail:
    mysqld IS running on server
    can ping to 192.168.0.1 from 192.168.0.23
    mysqladmin -u root -p*** ping reports "mysqld is alive"
    nmap localhost shows port 3306/tcp open mysql
    my.conf does NOT have a line for skip-networking - further, at mysql prompt: SHOW VARIABLES LIKE "skip-networking"; shows the value is OFF

Can build db's on the Fedora Box, add tables, fields and values all with no problems.

But cannot connect to MySql from the Windows Box

Any ideas where to go next?
Thanks,
Ric
Avatar of ric_m
ric_m

ASKER

Hi... Here is something that might help.

The Linux Box is also a gateway to the net. When configuring ftp and NameVirtualServers two separate problems were encountered with SELinux. Thios may still be the case with MySQL network connections. However...

The Linux Box is running Firestarter. If I check out iptables "service iptables status" I get a whole bunch of stuff that, frankly I can't figure out. If I do a "service iptables stop" I loose all NAT routing for the network behind the box but, for the first time, I get MySQL-Front working from any XP machine on the network.

So.. iptables?

Ric
ASKER CERTIFIED SOLUTION
Avatar of PAQ_Man
PAQ_Man
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial