【解决】client does not support authentication

用Navicat连接mysql时出现错误：
client does not support authentication...



解决方案：

USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;