mysql授权

create user 'test1'@'%' identified by 'mima';

// 给数据库所有权限
grant all privileges on db1.* to 'test1'@'%';
grant all privileges on db2.* to 'test1'@'%';

// 给表权限

grant all privileges on db2.table1 to 'test1'@'%';

// 给视图权限

grant all privileges on db2.view1 to 'test1'@'%';

// 给视图查看权限

GRANT show view on db2.view2 TO 'test1'@'%';

// 只给查询权限

grant select on db2.table2 to 'test1'@'%';

// 给函数权限

GRANT EXECUTE  ON  function  db1.func1 TO 'test1'@'%';

// 授权后都要执行
FLUSH PRIVILEGES;

// 收回权限，比如收回表权限

revoke all privileges on db2.table1 from 'test1'@'%';

修改密码
ALTER USER 'PRLisHlx'@'%' IDENTIFIED WITH mysql_native_password BY 'tj2207_hlxOrcl';

FLUSH PRIVILEGES;