[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
来源:互联网 发布:win10 预装软件 编辑:程序博客网 时间:2024/05/17 22:10
前几天我把自己测试机器的mysql data目录下的文件全删除了。
启动数据库报错:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
解决办法:
运行mysql_install_db。
如:
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
阅读全文
0 0
- [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- MySQL启动失败[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- MySQL:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql启动(Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist)
- MySQL故障 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- windows下Mysql解决Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解决办法
- Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist的解决方法
- IT运维与IT运营,你分清楚了吗?
- 500. Keyboard Row
- 阿里的fastjson使用总结
- 获取服务器时间
- 64. Minimum Path Sum
- [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- Difference between physically exclusive,logically exclusive and async clock groups
- Spring框架的七大模块?你知道各个模块的功能吗?
- 欢迎使用CSDN-markdown编辑器
- marquee实现无缝滚动
- 关于A标签使用onclick事件的疑问,若是href="#",跳转无反应,以及href=#与href=javascript:void(0)的区别
- ActiveMQ全解析
- 目前世界上最大的民航机是什么机型?
- Unity Shader入门精要笔记(十):Unity 的基础光照——高光反射的实现