MySQL: Client does not support authentication protocol requested by server

使用 Navicat连接Mysql报错
Client does not support authentication protocol requested by server

创建用户授权语句有问题.参考

CREATE USER '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `api`.* TO '用户名'@'%';

GRANT SELECT ON `mysql`.`user` TO '用户'@'%';

FLUSH PRIVILEGES;

如创建用户,修改用户信息参考

USE mysql;

ALTER USER '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '新密码';

FLUSH PRIVILEGES;