Job for mysqld.service failed in Centos 7

Check below things to fix the issue

  1. Check the permission of mysql data dir using below command. The ownership should be mysql:mysql and the directory permission should be 700

    ls -ld /var/lib/mysql/
    
  2. Check the permission of databases inside mysql data dir using below command. The ownership should be mysql:mysql for all the files inside that directory

    ls -lh /var/lib/mysql/
    
  3. Check the listening network tcp ports using below command

    netstat -ntlp
    
  4. Check the mysql log files for any error using below command.

    cat /var/log/mysql/mysqld.log
    
  5. Try to start mysql using below command

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

Tags:

Mysql

Centos7