Collections:
Listing All User Accounts in MySQL
How To List All Existing User Accounts in MySQL?
✍: FYIcenter.com
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)
⇒ Rename an Existing User Account in MySQL
⇐ Deleting a User Account in MySQL
2017-12-13, 1384🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...