\t\t解决mysql“Access denied for user 'root'@'localhost'”
来源:互联网 发布:阿里云自动测试代码 编辑:程序博客网 时间:2024/06/01 23:08
系统是Ubuntu9.04,出现问题如下:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决方法:
方法一:
# /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>
方法二:
直接使用/etc/mysql/debian.cnf文件中[client]节提供的用户名和密码:
# mysql -udebian-sys-maint -p
Enter password: <输入[client]节的密码>
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>
转载地址:http://blog.
- \t\t解决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'”问题的解决
- \t\t对一个C++函数的效率优化(好,转载)
- jsonuntil
- \t\tASE产生排名除使用identity外另外的方式(转载)
- weex的环境搭建
- dp专题 第二十三题 大盗阿福
- \t\t解决mysql“Access denied for user 'root'@'localhost'”
- http,sccket
- GMSK调制解调(一)
- \t\t关于Ubuntu下IP地址的问题
- http
- \t\tsizeof(char*)几个字节?
- 创建四角星按钮
- \t\tint类型到底占几个字节?
- syslog