MySQL - Predefined User Accounts in MySQL

"root" was created during the installation process.
"root" has no password initially. You need to assign a new password as soon as you finishes the installation.
"root" has all access privileges granted.

Here is a tutorial exercise to check the "root" user account:

>cd \mysql\bin
>mysql -u root

mysql> USE mysql;
Database changed

mysql> SELECT User, Password, Shutdown_priv, Create_priv 
    -> FROM user WHERE User = 'root';
+------+----------+---------------+-------------+
| User | Password | Shutdown_priv | Create_priv |
+------+----------+---------------+-------------+
| root |          | Y             | Y           |
+------+----------+---------------+-------------+
1 row in set (0.00 sec)

⇒Managing User Accounts and Access Privileges in MySQL

⇒⇒MySQL Database Tutorials

2017-09-08, 455👍, 0💬