• Go To Website
  • Go To Website
home/Knowledge Base/Databases/Using cPanel to Access a MySQL Database Remotely
Popular Search:Reseller Hosting, VPS Hosting, Professional Mail

Using cPanel to Access a MySQL Database Remotely

Updated on April 10, 2022

It makes sense to use remote database connections from your cPanel if you have external contributors to your website or if your database is hosted on a different server. Here’s how to go about doing it:

Take note of the IP address of the server from which you plan to connect remotely. http://whatismyipaddress.com/ should be able to assist you in determining your IP address.

Look for ‘Databases’ and then ‘Remote MySQL’ in your cPanel account.

Using a MySQL Database Remotely with cPanel

 

By selecting it, you will be taken to a new page with a ‘Host’ area where you can input the IP address (or host name) we found earlier and select ‘Add Host’ to add it. You can use the’percent’character to provide database access to all IP addresses beginning with 167.45.0, for example, by simply typing 167.45.0. percent.

Remote MySQL Databas

 

MySQL Workbench (https://www.mysql.com/products/workbench/) and Navicat (https://www.navicat.com/en/products/navicat-for-mysql) are two popular options for setting your remote MySQL. You’ll need your hostname, the name of your database, the credentials for the database, the port number 3306, and, if necessary, TCP/IP as the connection method.

If you no longer require database access, simply return to the ‘Remote MySQL’ function and locate the host in issue, then click ‘Delete’ next to its name, then confirm using the ‘Remove Access Host’ button.

Was this helpful?

Yes  No
Related Articles
  • How to add a sub-domain in the Cpanel Jupiter
  • How to Install WordPress Online Using Softaculous App Installer
  • Enable or Disable PHP’s GD Extension in cPanel
  • Creating MySQL Users and Databases
  • Listed Hosting Nameservers
  • What is an index page?
Leave A Comment Cancel reply

Databases
  • Using cPanel to Access a MySQL Database Remotely
  • Creating MySQL Users and Databases
  • Cron Jobs: An Overview
  • How to Improve the Performance of Your Hosting
  • A High-Level Overview of HTTP 2
  • Two Simple Methods for Exporting and Importing MySQL Databases
View All 6  
Popular Articles
  • How to Install WordPress Online Using Softaculous App Installer
  • How do I set up my domain’s personal Nameservers?
  • Listed Hosting Nameservers
  • What does “Awaiting release from previous registrar” transfer status mean?
  • How to Preview Your Website on Our Servers
Categories
  • Cloud VPS
  • Migration
  • Resellers
  • Security
    • SSL
  • Databases
  • Affliates
  • WordPress
  • Billings & Payments
  • Email
  • Files & Access
  • PHP
  • Nameservers
  • cPanel
    • Softaculous
  • Professional Business Mail
  • Backup
  • General
  • Domain
    • Transfer
  • SSD Hosting

  Using phpMyAdmin

Stopping display of all files on web page  

  • © 2022. Listed Hosting. All Rights Reserved.

Popular Search:Reseller Hosting, VPS Hosting, Professional Mail