MySQL User management

Note: (MySQL database is not case-sensitive, but the symbol must be in English format)

View User commands:select user,authentication_string,host from user;

Create user command one, directly created:create user ' zhangsan ' @ ' localhost ' identified by ' abc123 ';

Create user command two, permission creation:Grant all on . to ' lisi ' @ ' localhost ' identified by ' abc123 ';

Change Password command:set password for ' Zhangsan ' @ ' localhost ' = password (' 123abc ');

change username:Rename user ' lisi ' @ ' localhost ' to ' wangwu ' @ ' localhost ';

Workaround for password forgetting (mysql5.7 version)

Insert under "Mysqld"

Skip-grant-tables

MySQL User management