1045-Access denied for user ‘root‘@‘localhost‘

找到安装mysql的目录，在bin目录下cmd命令执行mysql -u root -p 

mysql> USE mysql ; 
mysql> UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ; 

mysql> flush privileges ; 
mysql> quit；

重启mysql服务

 

由于版本问题，修改密码可能错误，改为ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

 

转载

https://blog.csdn.net/ad996454914/article/details/80904771