(mysql.info.gz) CREATE USER

Info Catalog

(mysql.info.gz) Account management SQL

(mysql.info.gz) Account management SQL

(mysql.info.gz) DROP USER

 
 13.5.1.1 `CREATE USER' Syntax
 .............................
 
      CREATE USER USER [IDENTIFIED BY [PASSWORD] 'PASSWORD']
          [, USER [IDENTIFIED BY [PASSWORD] 'PASSWORD']] ...
 
 The `CREATE USER' statement creates new MySQL accounts.  To use it, you
 must have the `GRANT OPTION' 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.  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.
 
 The `CREATE USER' statement was added in MySQL 5.0.2.
 

Info Catalog

(mysql.info.gz) Account management SQL

(mysql.info.gz) Account management SQL

(mysql.info.gz) DROP USER