mysql用户创建授权

创建用户:
grant select,update,insert,delete,create,drop,alter,index on *.* to 'jyx_mysql'@'%' identified by '12study.mysql';
flush privileges;

grant select,update,insert,delete,create,drop,alter,index on jyx_bjdy.*     to 'jyx_mysql'@'%' identified by '12study.mysql';

posted on 2019-04-29 18:07  朱春旺  阅读(94)  评论(0编辑  收藏  举报