MYsql:1045 access denied for user 'root'@'localhost' using password yes 报错问题
来源:互联网 发布:mac 建筑 软件 免费 编辑:程序博客网 时间:2024/05/17 23:22
我采用了其中的一种解决方法。
1.net stop mysql 停用服务
2.修改${mysql_home}/MySQL Server 5.1目录下的my.ini文件
[mysqld]下面添加这句:
skip_grant_tables
3.把你的${mysql_home}/bin目录加入path路径里边
4.net start mysql 启动mysql服务
5.mysql -uroot -p
Enter password:root
6.mysql>UPDATE user SET Password=PASSWORD('root') where USER='root';
mysql>FLUSH PRIVILEGES;
mysql>exit
7.删除my.ini中的这句话:skip_grant_tables
net stop mysql
net start mysql
8.可以登录了
0 0
- MYsql:1045 access denied for user 'root'@'localhost' using password yes 报错问题
- MySQL改密码报错:ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySQL for mac 连接报错:Access denied for user 'root'@'localhost' (using password: YES)
- linux 下mysql 报 ERROR 1045 (28000): Access denied for user '-root'@'localhost' (using password: YES)
- mysql报错 Access denied for user 'root'@'localhost' (using password: YES)
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql 链接报错Access denied for user 'root'@'localhost' (using password :Yes
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- 连接mysql报错Access denied for user 'root'@'localhost' (using password: YES)解决办法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”)的处理方法
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- mysql access denied for user'root'@'localhost' using password yes
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql:Access denied for user 'root'@'localhost' (using password:YES)
- CentOS---图形界面和命令行切换
- Elasticsearch2.x Breaking changes
- 设计模式学习笔记(1)编辑中
- 学习使用stringstream stream;
- 简单排序(冒泡、选择、插入)总结
- MYsql:1045 access denied for user 'root'@'localhost' using password yes 报错问题
- 重载、构造方法、继承、GUI
- css 背景图片模糊 上面内容不模糊
- ubuntu 安装cuda driver失败的问题
- 913课堂笔记
- Hawq学习笔记 --- 清空数据库中表的数据
- ubuntu16.04安装iNode客户端心得总结
- iOS本地通知——每天固定时间发送通知
- 使用git建立远程仓库,让别人git clone 下来