十月 14th, 2017
comments
Closed

快速创建用户

grant all on *.*   to ‘mvpbang’@’localhost’  identified by ‘123123’;

grant all on *.*   to ‘mvpbang’@’%’  identified by ‘123123’;test

00、创建用户

create user ‘mvpbang’@’localhost’  identified by ‘123123’;
create user ‘mvpbang’@’%’            identified by ‘d123123’;

01、用户授权

grant all on *.* to ‘user1’@’localhost’;

grant select on *.*  to ‘mvpbang’@’localhost’;

grant select on *.*  to  szcx;

Comments are closed.