Alternatively, you can click the copy icon under Connection to retrieve the database client connection command. This already includes your database IP and port.
How to connect to a Database Instance
Reviewed on 02 September 2024 • Published on 16 February 2023
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
-
Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.
-
Click the database name or «See more Icon» > More info to access the Database Instance information page.
-
Retrieve the Database Instance IP and port from the Database Instance information section.
Note -
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 -
Enter the password that you defined upon Database Instance creation.
You are now connected to your Managed Database.
Was this page helpful?