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

Precautions

In AnalyticDB for MySQL, only a privileged account can be used to query database account information.

Note A privilege account in AnalyticDB for MySQL is equivalent to a root account in MySQL.

Procedure

Execute the following statement to query the database account, hostname, and password information:

USE MYSQL;
SELECT User, Host, Password FROM mysql.user;           
The following information is returned:
+---------+-----+--------------------------+
| User    | Host| Password                 |
+---------+-----+--------------------------+
| account1|  %  | *61f3777f02386598cd***** |
| account2|  %  | *0fe79c07e168cabc99***** |