Establishing remote connection to the MySQL database

Establishing remote connection to the MySQL database

Note: In this tutorial, we will be using DBeaver.

1.Open DBeaver
  1.  Launch DBeaver.
2. Create a New Connection
  1. Click the "New Database Connection" button or press Ctrl + Shift + N.
  2. In the list that appears, select MySQL (you can type "MySQL" in the search bar).

3. Configure the connection details

After selecting MySQL, configure the following fields:

  • Host: You can use the main domain of your hosting account or the MySQL server address (e.g., localhost or 127.0.0.1).

  • Port: The default port is usually 3306.

  • Database: The name of the database you want to access.

  • Username: Your MySQL username.

  • Password: The password for the user.


    • Related Articles

    • MySQL Database

      MySQL databases are required to run many web-based applications, such as information dashboards, content management systems, and online shopping carts. Step 1 Logged into your cPanel, in the DATABASE tab, locate the item “Manage My Database” note: ...

    • Creating a MySQL Database

      The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "Databases" ...

    • Remote Dtabese Access

      Add a specific domain name or IP to allow visitors to connect to MySQL databases. Step 1Logged into your cPanel in the “Database” section, locate the “Remote MySQL” item. Step 2 Now enter the hostname (domain, server or IP address). The wildcard ...

    • How to change database charset - MySQL

      To change the MySQL charset, follow these steps: 1. Access the cPanel: Log in to your cPanel account. 2. Access phpMyAdmin: In cPanel, find the "Databases" section and click on "phpMyAdmin". 3. Select the Database: In phpMyAdmin, on the left panel, ...

    • How to upload a firebird database to your hosting acount

      If you already have a Firebird database and want to upload it to your hosting account, just follow these steps: Step 1 1. Save/export your local database with the user that accesses your hosting. The password must contain exactly 8 characters, you ...