When I set the bind-address to the IP of the RPi, it will not start at boot. It will only work if I set the bind-address to '127.0.0.1', 'localhost' or 0.0.0.0. The syslog provides the following info with the IP set to the RPi's static IP:Aug  2 10:54:43 raspberrypi /etc/init.d/mysql[3065]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted inAug  2 10:54:43 raspberrypi /etc/init.d/mysql[3065]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failedAug  2 10:54:43 raspberrypi /etc/init.d/mysql[3065]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'Aug  2 10:54:43 raspberrypi /etc/init.d/mysql[3065]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!Aug  2 10:54:43 raspberrypi /etc/init.d/mysql[3065]:Why is this not working?Edit: Despite this question being marked as a duplicate, the 'duplicate' question merely offers a solution I am already aware of and have stated in my question (Use 0.0.0.0 instead) but this does not answer my question! I asked why is this not working? It worked fine in a previous install but not now so I'd like to know why it doesn't work.
MySQL won't start at boot with bind-address set to IP
mysql;raspbian