DBeaver MySQL Connection

Easily connect your MySQL hosting deployments at ScaleGrid to your DBeaver database administrator tool to optimize your MySQL management in the cloud.

How to Connect MySQL to DBeaver

1. Open up your DBeaver program.
2. Create a new connection by clicking the New Connection Wizard button in the application toolbar or in the Database Navigator view toolbar:

3. Search and select MySQL for the type of database, and click Next.

4. In the Connection Settings window that opens up, enter the hostname of the deployment found in your ScaleGrid MySQL Connection String under the Server Host field.
5. Enter port number (default is 3306), and the name of the database you’re trying to connect under Port and Database.
6. Under User name and Password, enter the Username and Password provided on the ScaleGrid console under the Credentials section of your MySQL cluster details page, or any other MySQL user you have created.

🚧

Note - your user should have appropriate permissions to access the database chosen.

🚧

Non SSL-Enabled Deployments

If your deployment is not SSL-enabled, skip to step 10 below.

7. Download your SSL certificate from the Get SSL CA Cert section on your MySQL cluster details page.
8. Go to the SSL tab in the DBeaver Connection Settings, and select the Use SSL checkbox.
9. Enter the path to your SSL certificate under CA certificate, and select the Require SSL and Verify server certificate checkboxes.

10. Review your entered information, and select Test Connection. If it shows Connected, select Finish.

👍

Your MySQL deployment at ScaleGrid is now connected to your DBeaver database administrator tool!

Read our comprehensive tutorial on DBeaver MySQL connection and if you have any questions, please reach out to us at [email protected].