What Are the Predefined User Accounts
Q
What Are the Predefined User Accounts? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: 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)
2007-05-10, 5337👍, 0💬
Related Topics:
