ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) 的解决办法 ---linux
来源:互联网 发布:高中课程视频教学软件 编辑:程序博客网 时间:2024/05/20 23:57
本人用的centos系统,刚刚在捣鼓mysql的时候不小心把user表里面的密码改了, 也不知道是不是这个原因,出现了下面这个错误提示:
ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
后来在网上查了以下解决办法, 也试了几种, 最后终于成功了。 方法如下:
# sudo /etc/init.d/mysql stop
# sudo 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
这样就算是成功了~~
hope it helps
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) 的解决办法 ---linux
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- linux下ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- linux中ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux下mysql出错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql中出现 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的解决办法
- MySQL 报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 的解决办法
- Ubuntu下 MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)”
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)(YES也一样的)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)问题的解决办法
- Linux mysql: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 的解决办
- error: 'Access denied for user 'root'@'localhost' (using password: NO)'
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: no)
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Javascript绝句欣赏
- linux 下阻塞睡眠等待poll函数简单实现
- android viewholder
- JS只能输入数字,数字和字母等的正则表达式
- segmentation fault
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) 的解决办法 ---linux
- sscanf 函数
- 每个JAVA初学者都应该搞懂的六个问题
- 多台机器远程安装应用 ssh
- Android 中的 Service 全面总结
- 使用ViewFlipper和translate动画实现滑屏切换画面——translate
- 对C++对象创建的理解
- 关于Mysql的Qcache优化
- win xp 安装windows phone 开发环境