数据库启动失败的时候,在/usr/local/mysql/data/slave.uploking.com.err中查看到error,错误提示为:Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 其中路径的slave为主机名。 解决方法: 执行命令:(此命令是一条命令)/usr/local/mysql/bin/mysql_install_db --user=mysql --da...
090517 13:34:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 解决办法 在运行初始化权限表的时候使用增加参数--datadir ,命令格式为: shell> .../mysql_install_db --user=mysql --datadir=/usr/local/mysql/var...
The server quit without updating PID file (/usr/local/var/mysql/xxxiMac.local.pid). mysqld: Table 'mysql.plugin' doesn't exist [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it. 解决方法: unset TMPDIR mysql_install_db --verbose --user=mysql --basedir...
MySQL Can't open the mysql.plugin table. Please run mysql_upgrade to create it 解决办法 第一步 清空datadir指定的目录。 第二步 初始化MySQL mysqld --initialize 在指定的日志文件里会有初始化后的root用户密码。 2021-01-21T08:10:42.906785Z 1 [Note] A temporary password is generated for root@...
Can't open the mysql.plugin table. Please run mysql 简介: service mysqld start 报错 090517 13:34:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 090517 13:34:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' ...
51CTO博客已为您找到关于Can't open the mysql.plugin table. Please run mysql_upgrade to create it.的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及Can't open the mysql.plugin table. Please run mysql_upgrade to create it.问答内容。更多Can't open
mysql常见错误/usr/local/mysql/bin/mysqld: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 出现这种情况多数是找不到data目录,还有就是对data目录没有写入权限。
mysql常见错误/usr/local/mysql/bin/mysqld: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 出现这种情况多数是找不到data目录,还有就是对data目录没有写入权限。
/opt/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist 121122 21:36:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 121122 21:36:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist ...