Learn how to connect to a MySQL® database instance with MySQL® Workbench.
Cloud Databases allow you to focus on building and deploying cloud applications while OVHcloud takes care of the database infrastructure and maintenance in operational conditions.
Requirements
- Access to the OVHcloud Control Panel
- A Public Cloud project in your OVHcloud account
- A MySQL® database running on your OVHcloud Cloud Databases (this guide can help you to meet this requirement)
- Configure your MySQL® instance to accept incoming connections
- A MySQL® Workbench stable version installed and public network connectivity (Internet). This guide was made with MySQL® Workbench version 8.0.28.
Concept
A MySQL® instance can be managed in multiple ways. One of the easiest, yet powerful, is to use a Command Line Interface (CLI), as shown in our guide: Connect to MySQL® with CLI or by using programming languages, such as PHP or Python.
Another way is to interact directly using a management tool like MySQL® Workbench.
Instructions
Installation
MySQL Workbench can be downloaded for free by clicking here.
Once you have downloaded and installed it, follow the steps below to set up a remote connection to your MySQL® instance.
Connect with MySQL® Workbench
Configuration
Click the new connection + button.
In the Setup New Connection dialog box, fill in the Parameters tab form with the previously collected information.
Store the password for connection in the keychain.
Switch to the SSL tab and set Use SSL to Require.
Once done, select your new connection.
Congratulations, in the Schemas tab, you will see your databases.
Once connected, MySQL® Workbench facilitates many actions such as querying your databases and managing used or even imported data. Please read the official documentation to discover the whole feature list.
Go further
For more information and tutorials, please see our other Managed Databases & Analytics or Platform as a Service guides. You can also explore the guides for other OVHcloud products and services.
OVHcloud Managed Databases and Analytics:
- Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs.
- Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation.
- MongoDB® is a registered trademark of MongoDB, Inc.
- MySQL® is a registered trademark of Oracle and/or its affiliates.
- PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.