目录
insert语句创建用户
insert into user (host, user, password, ssl_ cipher , x509_ issuer , x509_ _subject) values
("主机号", "用户名",password("密码"),"","", "");
需要刷新权限
刷新权限后生效
update语句修改用户密码
update user set password=password( "密码")
where host="主机号" and user="用户名";
delete语句删除用户
delete from user where host="主机号”and user="用户名";
刷新权限
flush privileges;
不需要刷新权限
直接生效
create语句创建用户
create user "用户名"@"主机号" identified by "密码";
set语句修改密码
set password = password( "密码");
set password for "用户名"@"主机号" = password("密码");
drop语句删除用户
drop user "用户名"@"主机号";