How To Add a New User Account in MySQL?

If you want to add a new user account, you can connect to the server as "root" and use the "CREATE USER ..." command. The command syntax for create a new user account with a specified user name and password is:

CREATE USER userName IDENTIFIED BY 'passwordString';

This command will be executed by the MySQL server to create the user account and store the password in an encrypted format. Here is good tutorial exercise:

>cd \mysql\bin
>mysql -u root mysql

mysql> CREATE USER dev IDENTIFIED BY 'retneciyf';
Query OK, 0 rows affected (0.42 sec)

mysql> SELECT User, Password, Shutdown_priv FROM user;
+------+-------------------------------------------+-----+
| User | Password                                  | ... |
+------+-------------------------------------------+-----+
| root |                                           | Y   |
| dev  | *3735F1D8464342BA852E10101E55E422EBAAAF35 | N   |
+------+-------------------------------------------+-----+
2 rows in set (0.00 sec)

 

⇒Managing User Accounts and Access Privileges in MySQL

⇒⇒MySQL Database Tutorials