mysql重启报错,
[ERROR] InnoDB: Could not open or create the system tablespace. If you
tried to add new data files to the system tablespace, and it failed
here, you should now edit innodb_data_file_path in my.cnf back to what
it was, and remove the new ibdata files InnoDB created in this failed
attempt. InnoDB only wrote those files full of zeros, but did not yet
use them in any way. But be careful: do not remove old data files
which contain your precious data!
查看日志:tailf -n 100 /var/log/mysqld.log
InnoDB: Check that you do not already have another mysqld process
using the same InnoDB data or log files. InnoDB: Unable to lock
./ibdata1 error: 11
解决方案:
ps aux |grep mysql
kill 掉 mysql进程
cd /var/lib/mysql
删除 mysql.sock.lock 文件
启动mysql
systemctl start mysqld.service
参考地址:https://blog.csdn.net/zhang123456456/article/details/72854467