What Are the Predefined User Accounts


What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges

✍: FYIcenter.com


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)

2007-05-10, 4894👍, 0💬