start: Job failed to start Error while starting mysql
If you are not able to start mysql because of this error, try following solutions.
Solutions :
1) There should not be incorrect bind-address in my.cnf. If you have not uncommented it intentionally to enable binding, the line should be commented. If you are not sure about the address, comment the line and restart mysql.
2) Run following command and try to start mysql.
3) Remove logfiles and try to start mysql.
4) If mysqld_safe is running with mysql, kill mysqld_safe
5) If any of these solutions are not working for you, try final solution.
Remove and re-install mysql again.
Debian based :
If you are not able to start mysql because of this error, try following solutions.
Solutions :
1) There should not be incorrect bind-address in my.cnf. If you have not uncommented it intentionally to enable binding, the line should be commented. If you are not sure about the address, comment the line and restart mysql.
2) Run following command and try to start mysql.
$ sudo dpkg-reconfigure mysql-server-5.5
3) Remove logfiles and try to start mysql.
$ sudo rm -rf /var/lib/mysql/ib_logfile*
4) If mysqld_safe is running with mysql, kill mysqld_safe
$ sudo killall -9 mysqld_safe
5) If any of these solutions are not working for you, try final solution.
Remove and re-install mysql again.
Debian based :
Yum Based :$ sudo apt-get --purge remove mysql-server mysql-common mysql-client $ sudo apt-get install mysql-server mysql-common mysql-client
$ sudo yum --purge remove mysql-server mysql-common mysql-client $ sudo yum install mysql-server mysql-common mysql-client
