Log in to a database
This topic shows you how to log in to a MyBase instance.
Prerequisites
Obtain the connection information for your database. For more information, see View database endpoint.
Procedure
MyBase on ACK
-
Open the Data Management (DMS) console.
-
In the left navigation pane, expand Database Instance, and then click +.
-
In the Add Instance dialog box, select , and then click Next.
-
In the Basic Information section, configure the following parameters.
Parameter
Description
Network type
Select public network.
Instance region
Select the region where your MyBase instance is located.
Endpoint
Enter the public endpoint of the MyBase instance. For more information, see View database endpoint.
Port
The default value is 3306.
Database account
Enter the privileged account that was created with your MyBase instance.
NoteThis is not the root account, which by default does not support remote login.
Database password
Enter the password for the database account.
-
Click Test Connection. After the test is successful, click Submit.
MyBase on ECS
-
Connect to the ECS instance that hosts the data node.
-
To obtain ECS connection details, see Node Management.
-
To connect to an ECS instance, see Connect to an instance.
-
-
Change to the MySQL installation directory.
cd /usr/local/mysql8.0/mysql/8.0.36/bin/ -
Run the MySQL login command.
./mysql -h 127.0.0.1 -u root -p -
Enter your password and press Enter. The
mysql>prompt indicates a successful login.