Adding a New User Account in MySQL


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

2017-09-08, 220👍, 0💬