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 through the process.

1. Download and installation of MySQL Workbench
MySQL Workbench is a free tool that allows you to visually manage MySQL databases. 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 details from your cdmon panel
To connect, you will need your MySQL connection details. All of them can be found inside the cdmon panel. Below is exactly where to find 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 to access the database.
  2. You can find it at:
    1. Hosting management → Databases → MySQL users
    2. Here you will see the list of created MySQL users. 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 going to:
    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” toggle must be enabled to connect through Workbench.

3. Open MySQL Workbench
  1. When you open Workbench, you will see the main screen displaying the MySQL Connections section.


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 under
  • Hostname: the Web IP
  • Port: 3306
  • Username: your cdmon panel’s MySQL user


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 don't want to enter it every time.


  1. Click OK.

6. Connection created

You will now see your new connection on the Workbench main screen.

Click on it to access.

7. Database exploration

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


From here you can browse and work with your data.


For more information, you can contact us.

    • Related Articles

    • How to connect via FTP via webFTP

      In order to upload the website to your accommodation incdmon, you need an FTP manager. In the Control Panel ofcdmon, you have an intuitive web manager, which allows you to perform the most common operations. The features of the "WebFTP" service allow ...

    • How to access phpMyAdmin

      If you want to view, modify or delete data from your database, it is best to access via phpMyAdmin. phpMyAdmin is a database manager through the Internet browser. You can access it through the Hosting Control Panel by requiring MySQL access data. ...

    • The test platform is published with .mialias.net How is it solved?

      The test platform is a free service that allows you to have a hosting space without having a domain pointing to this test platform. This means that the test platform can be accessed with "internal" access, which is what we call with the ...

    • Basic SSH Manual

      Buy Web Domain and SSL certificates With SSH access, you can work with your files and directories securely, and with connection from an application or command interpreter. Here is an example of a command interpreter for each of the most used ...

    • How to import and export databases from phpMyAdmin

      From phpMyAdmin you can manage your databases, you can add, delete or create new content. Two of the most common operations when using phpMyAdmin is importing and exporting databases. 1.- Export database Use this option when you want to migrate a ...