- Open up your DBeaver program.
- Create a new connection by clicking the New Connection Wizard button in the application toolbar or in the Database Navigator view toolbar:
- Search and select MySQL for the type of database, and click Next.
- 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.
- Enter port number (default is 3306), and the name of the database you’re trying to connect under Port and Database.
- 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.
- Download your SSL certificate from the Get SSL CA Cert section on your MySQL cluster details page.
- Go to the SSL tab in the DBeaver Connection Settings, and select the Use SSL checkbox.
- Enter the path to your SSL certificate under CA certificate, and select the Require SSL and Verify server certificate checkboxes.
- 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!
If you have any questions, please reach out to us at [email protected].
Updated almost 2 years ago