【mysql】Mysql创建只读账号
首先可以查看mysql中所有的用户
SELECT user,host FROM mysql.user;
查看指定用户的权限情况
SELECT * FROM mysql.user WHERE user='root'
创建一个只读用户
CREATE USER 'readonly'@'%' IDENTIFIED BY 'readonly';
给用户赋予只读权限
GRANT SELECT ON mytestdb.* TO 'readonly'@'%';
刷新即可
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)