MySQL user creation, deletion, permission changes

To create a user:

CREATE USER ' username ' @ ' host ' identified by ' password ';

User delete:

DROP USER ' username ' @ ' host ';

Create a user and authorize:

GRANT privileges on Databasename.tablename to ' username ' @ ' host ' identified by ' password ';

With authorized users:

GRANT privileges on Databasename.tablename to ' username ' @ ' host ';

Revoke user rights:

REVOKE privileges on Databasename.tablename from ' username ' @ ' host ';

User access rights change:

UPDATE mysql.user SET host = ' host ' WHERE user = ' root ';

This article is from the "Wang Liming" blog, make sure to keep this source http://afterdawn.blog.51cto.com/7503144/1834711

MySQL user creation, deletion, permission changes