Can't connect to MySQL server remotely on RedHat 9
Hi, trying to be as descriptive as I can,
I have a MySQL 4.0.13 server running on RedHat 9.0.
I can connect locally using a user and password for which I issued a MySQL grant on any host.
I have 3 different scenarios producing virtually the same result:
1) I have a RedHat 9.0 system running outside the linksys router on which the MySQL server is running (external network connecting to the MySQL server).
2) A RedHat 9.0 system running inside the router on which the MySQL server is running and
3) An XP system running inside the router.
All 3 machines can ping the MySQL server machine and vice-versa. When trying to connect to the DB server with the MySQL client (mysql -h DB -u user -p databasename) I get the following errors from from the RedHat clients:
Error 2003: Can't connect to the MySQL server running on DB (111)
and from the XP client:
Error 2003: Can't connect to the MySQL server running on DB (10054)
I have no error msgs any other place (no log files). I have no my.cnf file on the database server machine.
What could my problems be? MySQL configuration? Linux configuration? Router configuration?
Sorry if this is too much info, but any help would greatly be appreciated.