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

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 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?
  • Website staging with Softaculous
Leave A Comment Cancel reply

cPanel
  • Using cPanel to Access a MySQL Database Remotely
  • 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?
View All 74  
Popular Articles
  • How to Install WordPress Online Using Softaculous App Installer
  • How do I set up my domain’s personal Nameservers?
  • How to Preview Your Website on Our Servers
  • How do I use a browser to dynamically update the host’s IP?
  • Process Of Migration
Categories
  • WordPress
  • Billings & Payments
  • Email
  • Files & Access
  • PHP
  • Nameservers
  • cPanel
    • Softaculous
  • Backup
  • General
  • Domain
    • Transfer
  • SSD Hosting
  • Cloud VPS
  • Migration
  • Resellers
  • Security
    • SSL
  • Databases
  • Affliates

  Using phpMyAdmin

How to Improve the Performance of Your Hosting  

  • © 2022. Listed Hosting. All Rights Reserved.

Popular Search:Reseller Hosting, VPS Hosting