MySql 错误1067,1045( Can't open and lock privilege tables: Table 'mysql.user' doesn't exist)
来源:互联网 发布:手机域名注册管理局 编辑:程序博客网 时间:2024/05/16 13:37
由于不小心将mysql数据库删除了,导致MySql服务无法启动。打开“计算机管理->系统工具->事件查看器->Windows->应用程序”找到MySQL的错误日志:Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
正对以上问题进行修复,步骤如下:
1.A.如果是.msi文件安装MySQL的,则找到安装MySQL的安装文件,进行数据库的修复;
1.B.如果是压缩包的画,请将原压缩包中的data目录里的mysql文件夹复制到安装的MySql安装目录下的data文件夹下。
2.现在开启MySQL服务成功。cmd执行net start mysql
3.SQLyog连接MySQL数据库时报错1045。那是因为修复MySQL完成后,这时候的密码是默认密码,我也不知道是多少,所有现在就是更改密码。
4.停止MySql服务,然后打开my.ini文件,在[mysqld]下输入skip-grant-tables,保存之后重启MySQL服务
# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade to a newer version of MySQL.[mysqld]skip-grant-tables# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M
5.输入mysql -u root -p之后不用输入密码,出现password:直接回车进入MySQL。
6. 使用数据库:use mysql;
7. 更改密码:update user set password=password(“new_pass”) where user=”root”;
8. 刷新数据库:flush privileges;
9. 最后将在[mysqld]下输入的skip-grant-tables删除。
10. 5-8效果图如下:
11.经过以上步骤就已经大功告成,接着可以用SQLyog连接了。
- MySql 错误1067,1045( Can't open and lock privilege tables: Table 'mysql.user' doesn't exist)
- windows下 Mysql 错误1067 Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- windows下 Mysql 错误1067 Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- [MySQL]Fatalerror: 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
- [ERROR] 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
- 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解决办法
- Mysql linux 安装时遇到 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 error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 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
- Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 问题的解决方法
- MySQL error: Can’t open and lock privilege tables: table doesn’t exist
- Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 7、斐波那契数列 & 8、跳台阶 & 9、变态跳台阶
- ids for this class must be manually assigned before calling save()
- magento批量修改价格
- SpringMVC form表单 上传多个文件
- 感知机算法及应用学习笔记
- MySql 错误1067,1045( Can't open and lock privilege tables: Table 'mysql.user' doesn't exist)
- Jquery Validate 相关参数及常用的自定义验证规则
- MySQL——关于MySQL分组查询group by和order by获取最新时间内容的方法
- Teamviewer的简介
- 对display:table-cell的学习
- 读取配置文件工具类外挂在jar
- Java实现 数组实现队列
- 2017年4月美团Android面试总结
- 高可用保证消息绝对顺序消费的BROKER设计方案