MySQL 开启报错 Table mysql.plugin doesn t exist
发布时间：2022-06-29 13:47:24 所属栏目：MySql教程 来源：互联网
导读：启动报错： /opt/szy/bin/mysqld: Table mysql.plugin doesnt exist 141211 15:06:12 [ERROR] Cant open the mysql.plugin table. Please run mysql_upgrade to create it. 141211 15:06:14 [ERROR] Fatal error: Cant open and lock privilege table
|
启动报错： /opt/szy/bin/mysqld: Table 'mysql.plugin' doesn't exist 141211 15:06:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 141211 15:06:14 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 141211 15:06:14 mysqld_safe mysqld from pid file /opt/szy/data/mysqldevdb03.pid ended 解决办法： 执行如下语句，szy为实例名 ./scripts/mysql_install_db --user=szy --basedir=/opt/szy/ --datadir=/opt/szy/data/ 重启启动，OK！ （编辑：永州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐