MySQL - Listing All User Accounts in MySQL

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

2017-12-13, 594👍, 0💬

What Are User Privileges in MySQL
What Are User Privileges in MySQL? MySQL offers many user privileges to control user accesses to different functions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE comma... 2017-12-09, 656👍, 0💬

Listing All User Accounts in MySQL
How To List All Existing User Accounts in MySQL? 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&am... 2017-12-13, 595👍, 0💬

Rename an Existing User Account in MySQL
How To Rename an Existing User Account Name in MySQL? If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this: >cd \mysql\bin >mysql -u root -pretneciyf mysql mysql&gt... 2017-12-13, 556👍, 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, 539👍, 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.