创建用户命令
create
user
username@localhost identified
by
'password'
;
直接创建用户并授权的命令
grant
all
on
*.*
to
username@localhost identified
by
'password'
;
授予外网登陆权限
grant
all
privileges
on
*.*
to
username@
'%'
identified
by
'password'
;
授予权限并且可以新建
grant
all
privileges
on
*.*
to
username@
'hostname'
identified
by
'password'
with
grant
option
;