MySQL_创建只读用户

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT SELECT ON database_name.* TO 'username'@'%';
flush privileges;

grant select on 数据库名称 * to 'reader'@'%' identified by 'Dtx@db2020';
flush privileges;

show grants for reader

 

错误信息2058

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Tt65212879_';

FLUSH PRIVILEGES;

修改密码：
ALTER USER 'mci_1001'@'%' IDENTIFIED BY 'xxxx';

查看用户权限
SHOW GRANTS FOR 用户名