The remote mysql connection is disabled by default in Debian for security reasons. All you need to do is comment out the 'skip-networking' option in /etc/mysql/my.cnf.
I am pulling my hair out trying to figure out why I cant connect remotely. I setup an account with % as the host in the user table. Locally(or with ssh) I can connect to the server fine. Remotely not a chance. I noticed that port 3306 is not showing up when I do netstat -a or lsof -i :3306. I tried starting the server like "mysqld --port=3306". Nada, port 3306 is not open. I cannot figure why. I am running Debian 3.0r1 on 2 machines and cannot connect to either of them(both running mysqld). Any suggestions?
Thanks
Jamin
The remote mysql connection is disabled by default in Debian for security reasons. All you need to do is comment out the 'skip-networking' option in /etc/mysql/my.cnf.
Bookmarks