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***** |