mysql 用户创建和权限分配

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;