(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
automatically generated byinfo2html