How to connect to a Database Instance

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• A PostgreSQL or MySQL Database Instance

1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.

2. Click the database name or «See more Icon» > More info to access the Database Instance information page.

3. Retrieve the Database Instance IP and port from the Database Instance information section.

   Note

   Alternatively, you can click the copy icon under Connection to retrieve the database client connection command. This already includes your database IP and port.

4. Connect to your database with the database client of your engine.

   For MySQL, run the following command:

   mysql -h <ip-address> --port <port> -p -u <user_name>
   

   For PostgreSQL, run:

   psql -h <ip-address> -p <port> -U <username> -d rdb
   

5. Enter the password that you defined upon Database Instance creation.

You are now connected to your Managed Database.