linux下安装mysql后Access denied for user 'root'@'localhost' (using password: YES)

xiaoxiao2021-02-28  74

linux下安装mysql后Access denied for user 'root'@'localhost' (using password: YES) 

:https://zhidao.baidu.com/question/573063026.html

linux下安装mysql后  mysql -u root -p  Access denied for user 'root'@'localhost' (using password: YES) 什么密码都试过了,就是进不去

首先结束mysql进程,利用ps aux | grep mysql命令得到进程ID号,kill ID号,结束进程其次,运行mysqld --skip-grant-tables然后,再开一个终端,输入mysql -u root mysql进去后,执行UPDATE user SET Password=PASSWORD('my_password') where USER='root';再执行,FLUSH PRIVILEGES;退出,重启mysql,然后你再运行mysql -u root -p输入你的密码,应该就OK了

转载请注明原文地址: https://www.6miu.com/read-85224.html

最新回复(0)