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
MySQL Server

Avatar of undefined
Last Comment
PAQ_Man

8/22/2022 - Mon
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
ric_m

ASKER
ASKER CERTIFIED SOLUTION
PAQ_Man

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61