Navicat接続Mysqlエラー:Client does not support authentication protocol requested by server

483 ワード

Navicat接続新装Mysqlエラー:Client does not support authentication protocol requested by server...解決策:

インストールディレクトリ/bin

cd %PATH%\bin # %PATH% Mysql

登録mysql

#   
mysql -u root -p 
#     
Enter password: ************

パスワードのリセット

#   ， root：     ，123456：   
ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '123456'; 
#   MySQL        
FLUSH PRIVILEGES;