when you install the latest version of mysql, on Ali CVM, you can log in from the command line, but when you log in with navicat for mysql, you will be prompted
client does not support authentication protocol requested by server;consider upgrading MySql client
look for tutorials online and say that because the new mysql server version uses the new password authentication mechanism, the password needs to be changed
set password for "root"@"localhost"=old_password (" 123");
but when I change the password on the command line, I prompt for a syntax error:
Please tell me where the mistake is, thank you very much