解决报错:安装mysql5.6.44错误汇总

错误一
2021-04-02 17:32:48 77242 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
1、检查权限
2、检查配置文件
3、解决方案

错误二
FATAL ERROR: Could not find ./bin/my_print_defaults
解决方案

错误三
mysql_install_db --user=mysql --defaults-file=/etc/my3307.cnf --force
-bash: mysql_install_db: command not found
解决方案

错误四
Starting MySQL.Logging to '/data/mysql5.6/data/client1.err'.
ERROR! The server quit without updating PID file (/data/mysql5.6/data/client1.pid).
1、查看错误日志 cat /data/mysql5.6/data/client1.err | grep ERROR
解决方案

错误五
$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解决方案

错误六
$ /etc/init.d/mysqld5.6 stop
ERROR! MySQL server PID file could not be found!
这个报错,我kill掉原有的mysql进程后重启解决了。
解决方案

错误七
2021-04-04 15:31:29 87146 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2021-04-04 15:31:29 87146 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
注意:此方法会删除MySQL数据并初始化数据库,需要确认数据是否有备份,备份是否有效,需要谨慎操作!!!
解决方案1
解决方案2

posted @ 2021-04-03 11:06  努力吧阿团  阅读(400)  评论(0编辑  收藏  举报