edit-icon download-icon

View database information

Last Updated: Apr 05, 2018

The DRDS console allows you to view database details, delete databases, reset the password, and manage users with read-only access.

The procedure is as follows:

  1. On the DRDS console, click Databases in the left-side navigation pane.

  2. On the Databases page, click the name of the database you want to view.

    The Basic Information page appears.

    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. DRDS is fully compatible with MySQL, so you can operate DRDS 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 DRDS database.

Note:

  • Some MySQL clients of old versions require that the username contain no more than 16 characters. The DRDS 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 DRDS database from a MySQL client, you must add the “-c” parameter to the command line if you use hints. In DRDS, hints are implemented by commenting. If the “-c” parameter is not added, the comment is lost, causing loss of the DRDS hint.

Thank you! We've received your feedback.