Mysql account management_mysql

Mysql account management bitsCN.com

Mysql account management

1. create an account

Shell code

Create user 'jeffre' @ 'localhost' identified by 'My pass ';

2. delete an account (deleting an account also deletes all its permissions)

Shell code

Drop user 'Jeffrey '@ 'localhost ';

3. assign permissions

Shell code

Grant all privileges on *. * TO 'jeffre' @ '%' identified by 'password' WITH GRANT OPTION

4. revoke permissions

Shell code

Revoke insert on *. * FROM 'Jeffrey '@ 'localhost ';

Revoke all privileges, grant option from 'jeffre' @ 'localhost ';

5. account rename

Shell code

Rename user 'Jeffrey '@ 'localhost' TO 'Jeff' @ '2017. 0.0.1 ';

6. change the password

Shell code

Set password = PASSWORD ('mypass ');

Set password for 'jeffre' @ 'localhost' = PASSWORD ('mypass ');

BitsCN.com