Predefined User Accounts in MySQL

Home > 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)

⇒ Adding a New User Account in MySQL

⇐ What Is a User Account in MySQL

⇑ Managing User Accounts and Access Privileges in MySQL

⇑⇑ MySQL Database Tutorials

2017-09-08, 1505🔥, 0💬

Testing New User Account and Password in MySQL
How To Test a New User Account and Password in MySQL? If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords: &g... 2017-09-08, 2259🔥, 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, 1835🔥, 0💬

Chaning Other User's Password in MySQL
How To Change the Password of Another User Account in MySQL? If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of another user account. There are two ways to use this c... 2017-09-08, 1715🔥, 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, 1655🔥, 0💬

Deleting a User Account in MySQL
How To Delete a User Account in MySQL? If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >mysql -u root -pretneciyf mysql mysql... 2017-12-13, 1536🔥, 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, 1506🔥, 0💬

Returning Top 5 Rows in MySQL
How To Return Top 5 Rows in MySQL? If you want the query to return only the first 5 rows, you can use the LIMIT clause, which takes one parameter as the maximum number of rows to return. The following statement returns the first 5 rows from the fyi_links: mysql> SELECT id, url, counts, tag FR... 2017-12-21, 1495🔥, 0💬

Returning the Second 5 Rows in MySQL
How To Return the Second 5 Rows in MySQL? If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. You can use the "LIMIT startRow maxRows" clause to return only row... 2017-12-21, 1490🔥, 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, 1485🔥, 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.