Access denied for user 'root'@'localhost' (using password: YES)解决方法
来源:互联网 发布:eve男性捏脸数据 编辑:程序博客网 时间:2024/04/30 02:16
重新安装MySQL之后,最初用root无密码登录MySQL服务期之后更改了root密码成功,之后再用root登录MySQL服务器时,报出Access denied for user 'root'@'localhost' (using password: YES)这个错,总结了前人的经验之后按照我自己的解决知道解决了这个问题。
Windows平台下:
首先在服务中关闭MySQL服务,然后运行cmd命令,进入MySQL安装目录下的bin目录,如图:
再输入mysqld --skip-grant-tables之后回车,然后关闭此cmd命令行。
再打开cmd命令行,输入mysql -u root mysql回车,再输入UPDATE user SET Password=PASSWORD('my_password') where USER='root';再回车输入FLUSH PRIVILEGES;
关闭cmd命令行,在进程中找到mysqld.exe进程,关闭之。
重新启动MySQL服务,这样就解决啦
0 0
- Access denied for user 'root'@'localhost' (using password: YES)解决方法
- Access denied for user 'root'@'localhost' (using password:YES) 解决方法
- Access denied for user 'root'@'localhost' (using password:YES)解决方法
- Access denied for user 'root'@'localhost' (using password:YES)解决方法
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES) 问题解决
- 解决'Access denied for user 'root'@'localhost' (using password: YES)'
- access denied for user 'root'@'localhost' using password yes
- access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- Access denied for user 'root'@'localhost' (using password: YES)解决办法
- Access denied for user: 'root@localhost' (Using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES) 解决方案
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 快速排序的非递归实现
- java 服务治理方法
- iWatch 的text和label
- Xcode 6 后添加 PCH 文件 作为全局 头文件
- Android 微信支付body参数不支持中文的问题
- Access denied for user 'root'@'localhost' (using password: YES)解决方法
- Ubuntu如何从user用户切换到root用户
- magic(4*4)
- 05-图3. 六度空间 (30)
- 链表满足条件的一次性多个删除
- HUD 2648 解题报告
- Mybatis 示例之 foreach (上)
- JSF注册ManagedBean的流程
- HDU 4514 【非联通无向图判环,树直径】