MySQL Create, authorize, delete user

1. Create user

Create a username that is Lefunyun password is X5A4FU8I0LKM21YPYUZP account

CREATE USER [email protected] identified by ' X5A4FU8I0LKM21YPYUZP ';

2. Give account Authorization

Grant the account all permissions to the Lefuyun library, followed by the library name, and finally the password

Grant all privileges the lefuyun.* to [e-mail protected] identified by ' X5A4FU8I0LKM21YPYUZP ';

3. Delete User Lefuyun

Drop user Lefuyun;

　　

MySQL Create, authorize, delete user