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

时间:2023-03-09 17:56:22
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 2013 (HY000): Lost connection to MySQL server during query

bin/safe_mysqld --skip-grant-tables &

>mysql -uroot //另打开一个shell,执行Mysql
>use mysql //切换数据库为mysql
>update user set password=password("new_pass") where user="root"; //更新用户密码
>flush privileges; //更新Mysql权限表

mysql 出了这个问题,网上的各种解决方案,都不靠谱,最后看到一条

mysql_upgrade -uroot -padmin

解决问题

很靠谱