授权普通用户所有访问权限

创建新用户:

create user 'user01'@'127.0.0.1' identified by 'cssss@!';
create user 'user01'@'%' identified by 'cssss@!';

grant all privileges on *.* to 'cbi'@'10.122.44.155' identified by 'csss@!';
grant all privileges on *.* to 'cbi'@'%' identified by 'cssss@!';
FLUSH   PRIVILEGES; 

posted on 2021-05-18 16:14  一二三·  阅读(106)  评论(0编辑  收藏  举报

导航