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, 2031🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...