Collections:
Adding a New User Account in MySQL
How To Add a New User Account in MySQL?
✍: FYIcenter.com
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)
⇒ Testing New User Account and Password in MySQL
⇐ Predefined User Accounts in MySQL
2017-09-08, 1539🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...