mysql用户管理
快速创建用户
grant all on *.* to 'mvpbang'@'localhost' identified by '123123';
grant all on *.* to 'mvpbang'@'%' identified by '123123';
步步为营
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;