解决mysql Access denied for user 'root'@'localhost'
来源:互联网 发布:js xml createelement 编辑:程序博客网 时间:2024/06/05 23:04
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
使用网上介绍的方法修改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)'
现在终于被我找到了解决方法,如下:
1. 管理员登陆系统,停止mysql服务
# /etc/init.d/mysql stop
2.用以下命令启动MySQL,以不检查权限的方式启动;
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
3. 然后用空密码方式使用root用户登录 MySQL;
# mysql -u root
4. 修改root用户的密码;
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
4. 重新启动mysql服务;
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- mysql“Access denied for user 'root'@'localhost'”问题的解决
- 解决mysql“Access denied for user ‘root’@'localhost’”
- 解决mysql“Access denied for user root@localhost”
- 解决mysql“Access denied for user root@localhost”
- mysql“Access denied for user 'root'@'localhost'”问题的解决
- 【MySql】解决“Access denied for user 'root'@'localhost'”
- hibernate list和iterate 的区别 get和load的区别
- Android 实现View的渐隐渐现功能
- .net中using指令用法
- 【math】梯度(gradient)、雅克比矩阵(Jacobian)、海森矩阵(Hessian)
- C51浮点数显示、浮点数表示方法
- 解决mysql Access denied for user 'root'@'localhost'
- Spring MVC 通过@ResponseBody标签返回JSON数据 报406错误的解决方法
- 应用托管在SAE,不登录也能通过 phpmyadmin 管理数据库
- hadoop2.0 mvn compile -Pnative error
- 命名空间及匿名命名空间
- marking122部分文章列表
- android 短信(SMS)结构解析
- IOS7开发~解决UIWebView页面重叠问题
- 转 C++异常机制的实现方式和开销分析 白杨 http://baiy.cn