Heth at 09:25, 1 March 2025

2025-03-01T09:25:43Z

Heth: New page: Category:mysql Syntax CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] Here is an example: CREATE USER 'user1'@'localhost' I...

2009-02-18T14:59:22Z

New page: Category:mysql Syntax <source lang="sql"> CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] </source> Here is an example: <source lang="mysql"> CREATE USER 'user1'@'localhost' I...

New page

[[Category:mysql]]
Syntax
<source lang="sql">
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
</source>
Here is an example:

<source lang="mysql">
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';
</source>
Now if you check the mysql.user table you can find a new record in it. Notice that all priviliges are set to No so this user can do nothing in the DB. To add some preiviliges we can use the GRANT command as follows:

<source lang="mysql">
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';
</source>
Here we have added only the most important priviliges to the user. With the setting above this user is good to run a CMS or a blog, however with such settings this user is not able to install them as it can not create tables.

To add all priviliges to the user you don't have to list all of them but you can use the ALL shortcut as follows:

<source lang="mysql">
GRANT ALL ON *.* TO 'user1'@'localhost';

Database F1
You can create a new MySQL user in one step as well using again the GRANT command with a small extension as here:

<source lang="mysql">
GRANT ALL ON *.* TO 'user2'@'localhost' IDENTIFIED BY 'pass1';
</source>
The above examples used dedicated commands, but sumtimes you maybe want to add a new MySQL user via directly editing the mysql.user table. In this case you just inserts a new record into the table with a normal INSERT command:

<source lang="mysql">
INSERT INTO user (Host,User,Password)
VALUES('localhost','user3',PASSWORD('pass3'));
</source>
Or you can add some priviliges as well in a form like this:

<source lang="mysql">
INSERT INTO user (Host,User,Password,Select_priv,Insert_priv)
VALUES('localhost','user4',PASSWORD('pass3'),'Y','Y');
</source>

@@ Line 8: / Line 8: @@
 <source lang="mysql">
 CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';
 </source>
 Now if you check the mysql.user table you can find a new record in it. Notice that all priviliges are set to No so this user can do nothing in the DB. To add some preiviliges we can use the GRANT command as follows:

Mysql add user - Revision history

Heth at 09:25, 1 March 2025

Heth: New page: Category:mysql Syntax CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] Here is an example: CREATE USER 'user1'@'localhost' I...