mysql创建用户
create user 'user_name'@'allow_host' identified by 'pass_word';
mysql为用户分配权限
grant all privileges on `user_controller_database`.* to 'suer_name'@'allow_host' identified by 'pass_word';
分配完权限刷新权限
flush privileges;
create user 'user_name'@'allow_host' identified by 'pass_word';
grant all privileges on `user_controller_database`.* to 'suer_name'@'allow_host' identified by 'pass_word';
flush privileges;
本文标题:Mysql创建用户分配权限
本文链接:https://www.haomeiwen.com/subject/opalcftx.html
网友评论