Anilrgowda

Question: 2 machines running Linux
1 - redhat on new dell
1 - yellowdog on old powermac

I can open a remote mysql connection on redhat machine with these steps.
1. edit /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
# skip-networking

2. restart mysql daemon with /etc/init.d/mysqld restart

3. log into destination mysql as root
" GRANT ALL ON archive.* to user@remoteip identified by 'mypass';

4. Create WAN to LAN entry in Sonicwall to allow remote access to destination server

This works great on the Red Hat linux machine.
However, on the older Yellowdog, I keep getting this error:
" ERROR 2003: Can't connect to MySQL server on 'www.myserver.com' (110)

What I know:
" both machines are available to the outside www
" my.cnf files are identical
" hosts.allow & deny files are identical
" privileges for user attempting remote access are identical
" firewall rules are identical (except for I.P. of server)

What I don't know:
" much about YellowDog linux 2.3
" if the previous admin blo

------------------

Anilrgowda

on the yellowdog machine, you should see that the port number 3306 is open on all interfaces

netstat -an | grep 3306

should give a result with something like

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

this means that the computer is listening for any ip address to connect on to port 3306. also check and see if IPTABLES is running on that machine blocking that port.

iptables -L

------------------