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 (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

解决问题

很靠谱

如果觉得《ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)》对你有帮助，请点赞、收藏，并留下你的观点哦！