mysql8.0以上更改密码及授权

use mysql;

select user,host from mysql.user;

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

grant all privileges on 数据库.* to '用户名'@'%';

flush privileges;