lsof -i:3306
查看日志:
tail /var/log/mysqld.log
[ERROR] Can't start server: can't check PID filepath: No such file or directory
查看配置文件,找到pid文件位置
[root@wpaliyun ~]# cat /etc/my.cnf
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
创建目录:
[root@wpaliyun ~]# mkdir -p /var/run/mysqld
[root@wpaliyun ~]# chown mysql.mysql /var/run/mysqld
如果还不行,就创建一个pid文件并修改权限
[root@wpaliyun ~]# touch /var/run/mysqld/mysqld.pid
[root@wpaliyun ~]# chown mysql.mysql /var/run/mysqld/mysqld.pid