Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
来源:互联网 发布:怎样养淘宝小号 编辑:程序博客网 时间:2024/05/16 12:09
在Navicat for MySQL中不小心把mysql删了,后来启动mysql服务时报错:Windows 无法启动mysql服务(位于本地计算机上)。 错误1067:进程意外终止;
然后查看日志后(选择事件查看器然后选择windows日志,最后选择应用程序)发现有两处错误1、Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
2、Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
最后解决办法很简单,由于删了mysql只要将安装包中data文件下的mysql解压放到你的数据库文件(data)中,然后就可以正常启动mysql服务了。
然后查看日志后(选择事件查看器然后选择windows日志,最后选择应用程序)发现有两处错误1、Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
2、Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
最后解决办法很简单,由于删了mysql只要将安装包中data文件下的mysql解压放到你的数据库文件(data)中,然后就可以正常启动mysql服务了。
- [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.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:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' 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.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的解决方法
- centos 安装mono 遇到问题
- 关于html5的一些历史和优点
- 贪吃蛇类图和顺序图
- 字符,字节和编码
- ul li 更改样式
- Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
- eclipse Maven配置
- The Architecture of Open Source Application
- 深度LINUX启动软件中心一直处于“加载”状态
- android json解析及简单例子
- Emacs 显示行数
- SVM多类分类---多个二值分类combine
- Linux下安装和使用boost库
- ie和火狐下载时的兼容问题