Skip to main content

创建用户 分配权限


CREATE USER `arick`@`%` IDENTIFIED BY 'xuan' PASSWORD EXPIRE NEVER;

GRANT `root`@`localhost` TO `arick`@`%`;

SET DEFAULT ROLE `root`@`localhost` TO `arick`@`%`;

GRANT `arick`@`%` TO `root`@`localhost`;

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