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