mysql命令行创建用户并设置权限只读访问指定的数据库视图

1. mysql -h***.***.***.*** -u*** -p

2. use mydatabasename;

3. create view myview as select .......

4. create user 'myusername'@'%' identified by 'mypassword' (注意加引号）

5. grant select on mydatabasename.myview to 'myusername'@'%';