The PolarDB-X 1.0 console allows you to view database details, delete databases, reset the password, and manage users with read-only access.
Procedure
- Log on to the PolarDB for Xscale console.
- In the top navigation bar, select the region where the target instance is located.
- In the left-side navigation pane, click Instances.
- On the page that appears, find the target instance and click the instance ID.
- On the left menu bar, click Database Management.
- On the Databases page, click the name of the database you want to view.
On the Basic Information page, you can view the database name, status, work mode, and so on.
The command-line URL is used to log on to the database. PolarDB-X 1.0 is fully compatible with MySQL, so you can operate PolarDB-X 1.0 databases from a MySQL client. Copy and paste the command-line URL to the operating system client and enter the password to log on to the PolarDB-X 1.0 database.
Note- Some MySQL clients of old versions require that the username contain no more than 16 characters. The PolarDB-X 1.0 database name and username are the same. If you set the database name to a string of more than 16 characters during database creation, an error is returned.
- When you operate a PolarDB-X 1.0 database from a MySQL client, you must add the “-c” parameter to the command line if you use hints. In PolarDB-X 1.0, hints are implemented by commenting. If the “-c” parameter is not added, the comment is lost, causing loss of the PolarDB-X 1.0 hint.