MySQL创建用户并授权

MySQL创建用户并授权SQL:

create user user@localhost
    identified by 'password';

grant alter, 
alter routine, 
create, 
create routine, 
create temporary tables,
create view, 
delete, 
drop, 
event, 
execute, 
grant option, 
index, 
insert, 
lock tables, 
references, 
select, 
show view, 
trigger, 
update on databasename.* to user@localhost;

最近更新：10/11/2024, 4:55:25 AM

原文链接：MySQL创建用户并授权

上一篇：npm使用国内镜像加速|下一篇：Linux下jdk8环境变量配置