MySQL - Predefined User Accounts in MySQL

Home > MySQL

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, 626👍, 0💬

Managing User Accounts and Access Privileges in MySQL
Where to find answers to frequently asked questions on Managing User Accounts and Access Privileges in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing User Accounts and Access Privileges in MySQL. Clear answers are provided with tu... 2017-12-13, 672👍, 0💬

Adding a New User Account in MySQL
How To Add a New User Account in MySQL? 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 'passwordStrin... 2017-09-08, 651👍, 0💬

Predefined User Accounts in MySQL
What Are the Predefined User Accounts in MySQL? 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 ... 2017-09-08, 627👍, 0💬

What Is a User Account in MySQL
What Is a User Account in MySQL? A user account is identified by a user name and defines the user's attributes, including the following: Password for connection authentication. User privileges, for examples: Shutdown_priv, Create_priv, Drop_priv, Insert_priv, Update_priv, Delete_priv, etc.. Various ... 2017-12-13, 603👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.