【解决】client does not support authentication

cmd窗口登陆mysql:

C:\Users\Administrator>  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)

 

posted on 2018-09-26 17:08  asdyzh  阅读(856)  评论(0编辑  收藏  举报

导航