(mysql.info) create-user

(mysql.info) account-management-sql

 
 13.5.1.1 `CREATE USER' Syntax
 .............................
 
      CREATE USER USER [IDENTIFIED BY [PASSWORD] 'PASSWORD']
          [, USER [IDENTIFIED BY [PASSWORD] 'PASSWORD']] ...
 
 The `CREATE USER' statement was added in MySQL 5.0.2. This statement
 creates new MySQL accounts. To use it, you must have the global `CREATE
 USER' privilege or the `INSERT' privilege for the `mysql' database. For
 each account, `CREATE USER' creates a new record in the `mysql.user'
 table that has no privileges. An error occurs if the account already
 exists. Each account is named using the same format as for the `GRANT'
 statement; for example, `'jeffrey'@'localhost''. The user and host
 parts of the account name correspond to the `User' and `Host' column
 values of the `user' table row for the account.
 
 The account can be given a password with the optional `IDENTIFIED BY'
 clause. The USER value and the password are given the same way as for
 the `GRANT' statement. In particular, to specify the password in plain
 text, omit the `PASSWORD' keyword. To specify the password as the
 hashed value as returned by the `PASSWORD()' function, include the
 `PASSWORD' keyword. See  grant.

Info Catalog

(mysql.info) account-management-sql

(mysql.info) drop-user

automatically generated byinfo2html