Predefined User Accounts in MySQL

Q

What Are the Predefined User Accounts in MySQL?

✍: FYIcenter.com

A

There is only one predefined user account called "root":

  • "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, 346👍, 0💬