Can't connect to MySQL server error 111

This week I had to help someone out as there was an issue after there was a host IP change.  There was then an issue with people connecting to the database.

As it turned out if you do come accross this look in /etc/my.cnf, there is a line.

bind-address = ip.add.ress

This may be the old address for the server and this will stop connections, change this to your new address and restart MySQL/MariaDB and you should be good again.

I am always interested in feedback so please feel free to add any comments, or you can mail me  here.  If you would like to submit a quick tip  with full credit and links back to your site then also feel free to contact me.