MySQL错误:Starting MySQL..The server quit without updating PID file ([FAILED]al/mysql/data/iZ2ze5k93sw

MySQL错误:Starting MySQL..The server quit without updating PID file ([FAILED]al/mysql/data/iZ2ze5k93sw

 记录linux 启动mysql 错误,远程连接也报上图错误,参考文章https://blog.****.net/qq_36514672/article/details/81100981

1、编辑MySQL 配置文件 

vim /etc/init.d/mysql

2、找到start 模块,添加--user=root到mysqld_safe 即可

MySQL错误:Starting MySQL..The server quit without updating PID file ([FAILED]al/mysql/data/iZ2ze5k93sw

3、然后再进行启动MySQL,就会成功启动,重新测试

mysql -u root -p

输入密码,连接成功。

4、再看客户端远程连接

 MySQL错误:Starting MySQL..The server quit without updating PID file ([FAILED]al/mysql/data/iZ2ze5k93sw

ok,问题解决了

下方是我的公众号,欢迎关注,分享更多内容

MySQL错误:Starting MySQL..The server quit without updating PID file ([FAILED]al/mysql/data/iZ2ze5k93sw