Mysql account management

Mysql account management 1. CREATE an account Shell code create user 'jeffre' @ 'localhost' identified by 'my pass'; www.2cto.com 2. delete an account (deleting an account also deletes all its permissions) shell code drop user 'Jeffrey '@ 'localhost'; 3. Assign permissions to Shell code grant all privileges on *. * TO 'jeffre' @ '%' identified by 'Password' with grant option 4. REVOKE permission Shell code revoke insert on *. * FROM 'jeffre' @ 'localhost'; revoke all privileges, grant option from 'jeffre' @ 'localhost '; www.2cto.com 5. RENAME the Shell code rename user 'jeffre' @ 'localhost' TO 'jeff '@ '2017. 0.0.1 '; 6. Change the PASSWORD. Shell code: set password = PASSWORD ('mypass'); set password for 'jeffre' @ 'localhost' = PASSWORD ('mypass ');