Navicat link mysql display clinet dose not support authentication protocol request by server; Consider upgrading MySQL client

1 Enter mysql-uroot-p in the command window first via cmd into MySQL

2 Changing the encryption method

mysql>  ALTER USER ‘root‘ @ ‘localhost‘ IDENTIFIED  BY ‘password‘ PASSWORD EXPIRE NEVER; Query OK, 0  rows affected (0.10 sec)3 Changing your password mysql>  ALTER USER ‘root‘ @ ‘localhost‘ IDENTIFIED  WITH mysql_native_password  BY ‘123‘ ; Query OK, 0  rows affected (0.35 sec)This password is navicat link mysql password 4 refresh mysql> FLUSH  PRIVILEGES ; Query OK, 0  rows affected (0.28 sec)

Reference article: 80263215

Navicat link mysql display clinet dose not support authentication protocol request by server; Consider upgrading MySQL client