查看数据库用户，新增只读权限用户

1.查看全部用户权限

SELECT DISTINCT a.`User`,a.`Host`,a.password_expired,a.password_last_changed,a.password_lifetime,a.* FROM mysql.user a;

2.增加某个账号全部库表查看权限

GRANT SELECT ON *.* TO 'username'@'%' IDENTIFIED BY "password";

3.增加某个表或者视图查看权限

GRANT SELECT ON `xxxx-budget`.`hyfzxm` TO 'hfadmin'@'%';

4.增加某个表或者视图查看权限，同时设置用户密码

GRANT SELECT ON `xxxx-budget`.`hyfzjf` TO 'hfadmin'@'%' IDENTIFIED BY "Cfhcx2xxxx";