mysql 创建用户并授权

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`@`%`;