mysql数据库添加新用户,并授予所有权限

79 阅读1分钟
#创建用户
create user pidms_user identified by 'pidms_user';
#添加权限
grant all privileges on *.* to pidms_user@'%' identified by 'kcm123456';

flush privileges;