The DRDS console allows you to view database details, delete databases, reset the password, and manage users with read-only access.
You can perform the operations as follows:
- In the DRDS console, click Databases in the left-side navigation pane.
- On the Databases page, find the database you want to view and click its name. The Basic Information page appears.
The Basic Information displays the information of the database, such as the database name, status, and work mode.
Command Line URL is used to log on to the database. DRDS is fully compatible with MySQL, therefore, you can operate DRDS databases from a MySQL client. Copy and paste the Command Line URL to the operating system client and enter the logon password. You can then operate the DRDS database.
- Some MySQL clients of earlier versions have limits on the username length, which cannot be more than 16 characters. The DRDS database name and the 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 want to use a hint. DRDS hints are implemented based on comments, (similar to /*… */). If the -c parameter is not added, the comment is lost, causing loss of the DRDS hint.