All Documents
Current Document
Content is empty
If you don't find the content you expect, please try another search term
Content is empty
If you don't find the content you expect, please try another search term
Kingsoft Cloud Relational Database Service (KRDS)
Quick Start
Log in to a KRDS for MySQL instance
Last updated：2020-12-02 17:27:45
Step 1: Log in to the Kingsoft Cloud console. In the Products and Services section, click MySQL under Database to go to the KRDS for MySQL console. In the left navigation pane, click Instance. Click the ID of the instance or Manage in the Operation column. On the instance details page, click Login in to the database in the upper-right corner.
Step 2: On the database login page, enter admin as the account and the root password that you set during instance creation, and then click Login. You are connected to the KRDS for MySQL instance through phpMyAdmin.
Step 3: Perform operations as required. For example, you can view the schemas and objects in the database, create tables, and insert or query data.
Step 1: Log in to the Kingsoft Cloud console. In the Products and Services section, click MySQL under Database to go to the KRDS for MySQL console. In the left navigation pane, click Security Group. Add the IP address of your host to a security group that is associated with the instance.
Step 2: In the KRDS for MySQL console, click Instance in the left navigation pane. Click the ID of the instance. On the instance details page, find the IP address of the instance.
Step 3: Download and install the MySQL client on your host. For example, on CentOS 7.2 64-bit, you can use the package management utility Yum to download and install the MySQL client.
Run the following command:
yum install mysql
Step 4: Log in to the KRDS for MySQL instance by using the mysql command-line tool.
Run the following command:
mysql -h hostname -P port -u username -p password
In your command, replace hostname with the public IP address of the KRDS for MySQL instance, port with the port number for public access, username with admin, which is the default username for public access, and password with the password of the KRDS for MySQL instance.
Step 5: At the mysql> prompt, send SQL statements that you want to execute to the KRDS for MySQL instance. For more information, see mysql Client Commands.
Pure Mode