AnalyticDB for MySQL is compatible with MySQL databases. AnalyticDB for MySQL provides a built-in database named MySQL, which stores user information, permission information, and stored procedures of AnalyticDB for MySQL. You can execute a SELECT statement to query user information of AnalyticDB for MySQL.

Precautions

In AnalyticDB for MySQL, only the privileged account can query user information.

Note The privileged account in AnalyticDB for MySQL is equivalent to the root account in MySQL.

Example

USE MYSQL;
SELECT User, Host, Password FROM mysql.user;
+---------+-----+--------------------------+
| User    | Host| Password                 |
+---------+-----+--------------------------+
| account1|  %  | *61f3777f02386598cd***** |
| account2|  %  | *0fe79c07e168cabc99***** |