Listing All User Accounts in MySQL

Q

How To List All Existing User Accounts in MySQL?

✍: FYIcenter.com

A

MySQL stores all existing user accounts in a table called "mysql.user". If you want see all user accounts, you can use the "SELECT" command as shown in the tutorial exercise below:

>cd \mysql\bin
>mysql -u root -pretneciyf mysql

mysql> CREATE USER dba IDENTIFIED BY 'iyf';
Query OK, 0 rows affected (0.02 sec)

mysql> SELECT User, Password, Shutdown_priv FROM mysql.user;
+------+-------------------------------------------+-----+
| User | Password                                  | ... |
+------+-------------------------------------------+-----+
| root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y   |
| dba  | *446BD97F308FBA0B9CBDC962C2842AD338BCE59E | N   |
+------+-------------------------------------------+-----+
2 rows in set (0.03 sec)

 

Managing User Accounts and Access Privileges in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 183👍, 0💬