Remote Server: "Could not connect" with MySQL Administrator

[Roger Faught]

I am able to use PHPMyAdmin on the server to connect to the database. I have set up the user with the host (my ip address) for the user with all privileges (i.e root@###.###.###.###). I'm using the IP I get from the provider here; from whatismyip.com. I've verified that MySQL is listening on 3306 and that nothing on my laptop is preventing communication on that port; I even turned off the firewall. The my.cnf file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-name-resolve
skip-host-cache
max_connections=200
bind-address=###.###.###.###

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


I still cannot connect with MySQL Administrator. Any ideas on what's going on?



Edited 1 time(s). Last edit at 03/10/2011 03:00PM by Roger Faught.