Sidebar navigationMain contentFooter
Suggest an edit

How to connect to a Database Instance

Reviewed on 22 August 2023Published on 16 February 2023
Security & Identity (IAM)

To perform certain actions described below, you must either be the Owner of the Organization in which the actions will be performed, or an IAM user with the necessary permissions.

Requirements
  • You have an account and are logged into the Scaleway console
  • You have 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.

See also
How to create a Database InstanceHow to create a database
Cloud Products & Resources
  • Scaleway Console
  • Compute
  • Storage
  • Network
  • IoT
  • AI
Dedicated Products & Resources
  • Dedibox Console
  • Dedibox Servers
  • Network
  • Web Hosting
Scaleway
  • Scaleway.com
  • Blog
  • Careers
  • Scaleway Learning
Scaleway Docs
Follow us
FacebookTwitterSlackInstagramLinkedin
ContractsLegal NoticePrivacy PolicyCookie PolicyDocumentation license
© 1999-2024 – Scaleway SAS