ubuntu 系统解决mysql连接问题（ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:

清疚 2022-09-26 00:27 2阅读 0赞

# mysql -uroot -p #

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)’

现在终于被我找到了解决方法：  
切换到root用户，然后进入mysql 的bin目录后，  
root@cps-desktop:/usr/local/mysql/bin\# /etc/init.d/mysql stop  
root@cps-desktop:/usr/local/mysql/bin\# ./mysqld\_safe –user=mysql –skip-grant-tables –skip-networking&  
root@cps-desktop:/usr/local/mysql/bin\# ./mysql -u root mysql  
mysql> UPDATE user SET Password=PASSWORD(‘newpassword’) whereUSER=’root’;  
mysql> FLUSH PRIVILEGES;  
mysql> quit;

最后重启数据库：  
root@cps-desktop:/usr/local/mysql/bin\# /etc/init.d/mysql restart  
root@cps-desktop:/usr/local/mysql/bin\# mysql -u root -p  
Enter password: <输入新设的密码newpassword>

mysql>

最后还有一点要注意：  
/etc/mysql/my.cnf  
中这两行一定要注意掉，否则真的连不上！  
bind-address = 127.0.0.1  
bind-address = 0.0.0.0

ubuntu 系统解决mysql连接问题（ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关解决MySQL问题：ERROR 1045 (28000): Access denied for user ‘ODBC‘@‘localhost‘ (using password: NO)

相关 ubuntu 系统解决mysql连接问题（ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:

相关 HIVE-ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

相关解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

相关 mysql 解决ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)

相关 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)

相关解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

相关 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

相关 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

相关解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)