MySQL User management

MySQL User management

Quickly create users

Grant all on * * to ' mvpbang ' @ ' localhost ' identified by ' 123123 ';

Grant all on * * to ' mvpbang ' @ ' percent ' identified by ' 123123 ';

Step

00. Create User

Create user ' Mvpbang ' @ ' localhost ' identified by ' 123123 ';
Create user ' Mvpbang ' @ '% ' identified by ' d123123 ';

01. User Authorization

Grant all on * * to ' user1 ' @ ' localhost ';

Grant SELECT On * * to ' mvpbang ' @ ' localhost ';

Grant SELECT On *. * to SZCX;

MySQL User management