准备做同机的主备同步,执行如下命令:
/application/mysql/scripts/mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/data/3307/data
报错:
2023-12-21 22:24:22 83022 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2023-12-21 22:24:22 83022 [Note] InnoDB: Check that you do not already have another mysql d process using the same InnoDB data or log files.
分析:
[root@mv171 data]# ps -aux |grep mysql*
有其他mysql守护进程占用了锁资源?3307端口进程被占用。
解决办法:
把mysql3307进程杀掉:kill pid