How to connect to a database with MySQL Workbench

How to connect to a database with MySQL Workbench

Below we explain step by step how to establish a connection to your MySQL database using MySQL Workbench, including the necessary screenshots to guide you during the process.

1. Download and installation of MySQL Workbench
MySQL Workbench is a free tool that allows you to manage MySQL databases visually. You can download the latest version from the following link: 


Download the version corresponding to your operating system and install it.

2. Obtain the connection data from your cdmon panel
To connect you will need the MySQL connection data. All of them are available within the cdmon panel. Below we explain exactly where to locate each one.

Host / Hostname (Web IP)
  1. You must use the web IP of your service.
  2. You can find it by going to:
    1. Hosting management → Hosting information → Web IP
    2. In this section you will see the public IP assigned to your hosting. This is the value you must enter in “Hostname”.


MySQL user
  1. This is the user you will authenticate with in the database.
  2. You can find it in:
    1. Hosting management → Databases → MySQL Users
    2. Here you will see the list of MySQL users created. Select the one you use to access your database.


MySQL password
  1. The password is associated with a MySQL user.
  2. You can manage it from:
    1. Hosting management → Databases → MySQL Users
    2. The password cannot be viewed. You can only generate or regenerate a new one. When you generate it, copy that value: it will be the password you must enter in Workbench.

Database
  1. This is the name of the database you will connect to.
  2. You can check it by accessing:
    1. Hosting management → Databases → MySQL
    2. There you will see the list of databases available in your hosting.

Port
  1. The MySQL port is 3306.



NOTICE: The "External access" button must be enabled to connect using Workbench.

3. Open MySQL Workbench
  1. When opening Workbench you will see the main screen, where the MySQL Connections section appears.


4. Create a new connection


In MySQL Connections, click the + button to create a new connection.



The Setup New Connection window will open. Fill in the following fields:

  • Connection Name: the name you want to save it with
  • Hostname: the web IP
  • Port: 3306
  • Username: the MySQL user from your cdmon panel



Click OK. Workbench will ask for the MySQL password.

5. Enter the password
  1. Enter the password generated from MySQL Users.
  2. Check Save password in vault if you do not want to enter it each time.



  1. Click OK.

6. Connection created

Now you will see your new connection on the main Workbench screen.



Click on it to access.

7. Database exploration

In the left panel you will see:
  1. Databases (schemas)
  2. Tables
  3. Views
  4. Procedures
  5. Functions



From there you can browse and work with your data.


For more information, you can contact us.