项目场景:
需要备份数据库
问题描述
数据库连接时报错unknow database mysql_native_password
解决方案:
登入数据库
执行:select host,user,plugin from user;发现报错ERROR 1046 (3D000): No database selected
再执行
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '数据库密码';
FLUSH PRIVILEGES;
use mysql;
select host,user,plugin from user;
update user set plugin='mysql_native_password' where user='root';