ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
来源:互联网 发布:网络中继器设置方法 编辑:程序博客网 时间:2024/05/20 20:47
参考文章:http://blog.sina.com.cn/s/blog_6605f0730100zf6n.html
但是经试验过后有些问题,现在总结如下:
1、# service mysql stop
2、# mysqld_safe --user=mysql --skip-grant-tables --skip-networking&
3、# mysql -u root mysql
4、mysql> UPDATE user SETPassword=PASSWORD('newpassword') where USER='root' and host='root'or host='localhost';//把空的用户密码都修改成非空的密码就行了。
5、mysql> FLUSH PRIVILEGES;
6、mysql> quit
7、# service mysql start
8、# mysql -u root -p
Enter password: <输入新设的密码newpassword>
- 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)
- 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)
- ERROR 1045 (28000): 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)
- ERROR 1045 (28000): 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)
- [linux][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)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- NSLogger 日志工具
- 2012.09.24京东笔试
- innerHTML简单用法
- IOCP
- Openwrt编译生成虚拟机镜像
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 常用 无线路由的地址、用户名 、密码
- Riak介绍
- 汉语拼音新规将实施 拼音中文名须姓在前名在后
- ARM的CF卡驱动分析
- 你若安好
- tomcat健康状态监控
- C语言连接Mysql
- MonkeyRunner_Click on a View contains specified text using monkeyrunner and Android ViewClient