大势趋007

每个人都是🏆
  新随笔  :: 管理

error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes

Posted on 2021-10-05 15:07  大势趋007  阅读(35)  评论(0)    收藏  举报

error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes

/etc/init.d/mysqld stop
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
update user set password=password('pp') where user='root';
update user set authentication_string=password('pp') where user='root';
flush privileges;
/etc/init.d/mysqld restart
mysql -u root  -p