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, 1372🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...