MySQLStudy——账号权限管理

权限管理:

   创建用户
      create user '用户名'@'IP地址' identified by '密码';
      creaee user 'zekai'@'192.168.1.123' identified by '123qwe';
      creaee user 'zekai'@'192.168.1.%' identified by '123qwe';
      create user 'zekai'@'%' identified by '123qwe';

   删除用户
      drop user '用户名'@'IP地址';
   修改用户
      rename user '用户名'@'IP地址' to '新用户名'@'IP地址';

   修改密码
      set password for '用户名'@'IP地址' = Password('新密码')

   查看所有用户（root下）
      SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

   授权:
      grant  权限 on 数据库.表 to   '用户'@'IP地址'      -- 授权

      grant select on db1.*  to 'zekai'@'%';
      grant select on *.*  to 'zekai'@'%';
      grant select, insert, delete on db1.*  to 'zekai'@'%';

   记住:
      flush privileges;

转载于:https://www.cnblogs.com/tingguoguoyo/p/11042468.html