很多人写alter user ‘Xue‘@‘%‘ identified with mysql_native_password by ‘123456‘;
测试我本地不能用会报1396错误；
将%改为localhost可以连接成功；
alter user ‘Xue‘@‘localhost‘ identified with mysql_native_password by ‘123456‘;
FLUSH PRIVILEGES;
原文：https://www.cnblogs.com/1lwf/p/10145183.html