MySQL Not starting Tips/Tricks

MySQL

Check below things to fix the issue

Check the permission of mysql data dir using below command

ls -ld /var/lib/mysql/

Check the permission of databases inside mysql data dir using below command

ls -lh /var/lib/mysql/

Check the listening network tcp ports using below command

netstat -ntlp

Check the mysql log files for any error using below command.

cat /var/log/mysql/mysqld.log

Try to start mysql using below command

mysqld_safe –defaults-file=/etc/my.cf