解决'Access denied for user 'root'@'localhost' (using password: YES)'
来源:互联网 发布:信用贷款知乎 编辑:程序博客网 时间:2024/05/11 09:31
使用网上介绍的方法修改root用户的密码:
# mysqladmin -uroot -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
现在终于被我找到了解决方法,如下(请先测试方法三,谢谢!):
方法一:(注:我只走到第三步,不知道为什么用mysql -u root -p root竟然可以登录,根本还没有进mysql进行update更改操作呢,)
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>
- 解决'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
- 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)
- 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)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- as3 通信类总结
- ASP.NET MVC学习笔记-ViewEngine 深入解析与应用实例
- 一个wince c++ 模板源程序
- skycc营销软件我的生活好助手
- 软件工程师的爱
- 解决'Access denied for user 'root'@'localhost' (using password: YES)'
- flash 实时 通信
- outlook 最小化之后隐藏
- 批量加载SQL Server 表和SqlDataAdapter.Update数据源(1)
- C#程序实现动态调用DLL的研究(1)
- 文本框TextBox输入特定格式(“年-月-日”)的生日
- 數據庫同步
- C#程序实现动态调用DLL的研究(2)
- Report Services部署