mysql8.0 Authentication plugin 'caching_sha2_password' cannot be loaded

代码: 

cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"

C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
Enter password: *********

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newrootpassword';
Query OK, 0 rows affected (0.10 sec)

mysql> exit

来源:https://www.cnblogs.com/zzqc/p/9192217.html 

 

posted @ 2018-10-04 21:57  BloggerSb  阅读(365)  评论(0编辑  收藏  举报