1.mysql -uroot -p
2.输入密码进入后切换数据库
use mysql;
3.修改权限
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
4.查看
select host,user,plugin from user;
结束