mysql运行时报错，“Can't open the mysql.plugin table”
160424 14:14:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Initializing buffer pool, size = 8.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Started; log sequence number 0 43655
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
[ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50158. Please use mysql_upgrade to fix this error.
[ERROR] mysql.user has noEvent_privcolumn at position 29
[ERROR] Cannot open mysql.event
[ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
[Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.58' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Utter Ramblings
我是个mysql新手，在网上找了很久
解决方法是：在运行初始化权限表的时候使用增加参数--datadir ，命令格式为：
shell>
..../mysql_install_db --user=mysql --datadir=/usr/local/mysql/var但是我运行的出错。请大家帮帮小弟，谢谢啦
展开
收起
1
条回答
写回答
写回答
-
喜欢技术，喜欢努力的人查看一下配置文件
mysql_install_db --user=mysql --ldata=/var/lib/mysql/2019-07-17 18:48:36赞同 展开评论 打赏
问答标签：
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关问答
问答排行榜
最热
最新
推荐问答
