您的当前位置：首页正文

MySQL 新建用户和权限操作

来源：步旅网

连接数据库，新建用户

  set global validate_password_policy=0;
  set global validate_password_length=1;
  create user 'louis'@'%' identified by '111';

赋予所有权限

  grant all privileges on *.* to 'louis'@'%' identified by '111' with grant option;
  flush privileges;

赋予指定权限

  grant select,insert, update privileges on *.* to 'louis'@'%' identified by '111' with grant option;
  flush privileges;

收回所有权限

  revoke all privileges on *.* FROM louis;
  flush privileges;

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文