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, 1538🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...