I am trying to connect to mysql using an ip, but I am getting this error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
I can connect using
localhost instead of an ip though.
This doesn't work:
mysql -u ryan -h xxx.xxx.xxx.xxx -p
Yet this does work:
mysql -u ryan -h localhost -p
I was able to connect earlier today, then I installed iRedMail, then I uninstalled iRedMail, and the uninstall process did something to mysql I think so I reinstalled mysql from scratch using this:
apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5
apt-get install mysql-server
After that I created my user, and now I can't connect using an IP address with both the new user or root user, but I can connect using
What is wrong?