【解决】client does not support authentication

cmd窗口登陆mysql:

C:UsersAdministrator>  sqlplus  /nolog


mysql>  conn / as sysdba;

mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.10 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

原文地址:https://www.cnblogs.com/asdyzh/p/9708110.html