论坛首页 入门技术论坛

mysql 创建用户并授权

浏览 973 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
作者 正文
   发表时间:2017-07-09  

CREATE USER 'lushuifa'@'%' IDENTIFIED BY 'lushuifa';

 

GRANT USAGE ON *.* TO 'lushuifa'@'%' IDENTIFIED BY 'lushuifa'

WITH MAX_QUERIES_PER_HOUR 0

MAX_UPDATES_PER_HOUR 0

MAX_CONNECTIONS_PER_HOUR 0

MAX_USER_CONNECTIONS 0;

 

GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create User, Create View, Delete, Drop, Event, Execute, File, Grant Option, Index, Insert, Lock Tables, Process, References, Reload, Replication Client, Replication Slave, Select, Show Databases, Show View, Shutdown, Super, Trigger, Update ON *.* TO `lushuifa`@`%`;

论坛首页 入门技术版

跳转论坛:
Global site tag (gtag.js) - Google Analytics