更新时间:2022-01-25 06:33:59
mysql重启导致出现以下错误:
Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
删除ibdata1、ib_logfile* 相关文件 删除之前先备份
使用命令重启:
/usr/local/mysql/support-files/mysql.server start --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
这样只能正常启动mysql。 数据库表不能使用。。
[解决方法]MySql提示:The server quit without updating PID file(…)失败
mysql配置完半同步复制之后报错[ERROR] The server quit without updating PID file
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]
Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
Starting MySQL.The server quit without updating PID file (xxxx.pid).[FAILED]
Starting MySQL... ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
Starting MySQL. ERROR! The server quit without updating PID file