MYSQL Account Management

"MYSQL account Management "

You must connect root to the MySQL server as the MySQL user and which has the CREATE USER privilege.

　　CREATE USERCreates a new row in the mysql.user table.

Example 1:create An account that uses the default authentication plugin and the given password. Mark The password expired so, the user must choose a new one at the first connection to the server:

　　

Example 2:create An account that uses the sha256_password authentication plugin and the given password. Require that a new password is chosen every:

　　

Example:this statement creates and accounts, each with the default authentication plugin and named password. For both accounts, connections must is made using a valid X509 certificate and up to queries per hour is permitted. Both accounts is locked initially, so effectively they is placeholders and cannot is used until an administrator unlocks them:

　　

Example of a GRANT statement:

　　

To delete a user:

　　

Set Password:

　　

Reference: http://dev.mysql.com/doc/refman/5.7/en/account-management-sql.html

MYSQL Account Management