Use the Database Management section of the PolarDB for Xscale console to view connection details, manage read-only database users, reset passwords, and delete databases.
View database details
Log on to the PolarDB for Xscale console.
In the top navigation bar, select the region where your instance is located.
In the left-side navigation pane, click Instances.
Find the target instance and click the instance ID.
In the left menu bar, click Database Management.
On the Databases page, click the database name.
The Basic Information page displays the following information:
| Field | Description |
|---|---|
| Database name | The name of the database, which is also the username for MySQL client connections |
| Status | The current operational status of the database |
| Work mode | The database work mode |
| Command-line URL | The connection string for MySQL client access |
Connect to the database using a MySQL client
PolarDB-X 1.0 is fully compatible with MySQL. To connect from a MySQL client, copy the command-line URL from the Basic Information page, paste it into your operating system client, and enter your password to log on.
Keep the following constraints in mind:
Some older MySQL clients require usernames of 16 characters or fewer. Because the database name and username are identical in PolarDB-X 1.0, setting a database name longer than 16 characters during creation returns an error.
If you use hints with a MySQL client, add the
-cparameter to the command. PolarDB-X 1.0 implements hints through SQL comments. Without-c, the comment is stripped and the hint is lost.