1、创建用户
create user 用户名 identified by ‘密码’;
create user demo identified by ‘123456’;
2、分配权限
grant 权限 on 数据库.数据表 to ‘用户’ @ ‘主机名’;
grant all on * . * to ‘demo’@’%’ identified by ‘123′;
3、指定权限
grant 权限 on 数据库.数据表 to ‘用户’ @ ‘主机名’;
grant select on temp.temp1 to ‘demo’@’%’;
权限分配之后记得
flush privileges;