All Documents
Current Document

Content is empty

If you don't find the content you expect, please try another search term

Documentation

Log in to a KRDS for MySQL instance

Last updated:2020-12-02 17:27:45

Log in to an instance from Windows

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.

登录实例1.png

登录实例2.png

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.

image.png

Log in to an instance from Linux

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.

image.png

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.

On this page
Pure ModeNormal Mode

Pure Mode

Click to preview the document content in full screen
Feedback