Description: Learn how to enable remote access to your MySQL databases in cPanel and DirectAdmin. Connect securely from anywhere with ease. 🌐✅
What is remote MySQL access and what is it used for? 🤔
Remote MySQL access allows you to connect to your database from a location outside the server where it is hosted. This is useful for:
-
🖥️ Managing the database from your local computer.
-
🔗 Allowing external applications to access the stored data.
-
💾 Performing backups or migrations from another server.
What do you need to connect remotely? 🛠️
Before you begin, make sure you have the following:
-
🧾 Database name
-
👤 User with privileges
-
🔐 Password for the user
-
🌍 Database server (domain name or IP)
-
🚪 Port 3306 enabled (inbound and outbound)
How to enable remote access in cPanel 📲
-
🔐 Log into your cPanel account.
-
🗂️ Go to the Databases section and click on Remote MySQL®.
-
📝 In the Host field, enter the IP address you will connect from (use
%to allow all). -
🏷️ Add an optional comment to identify the host.
-
✅ Click Add Host.
💡 Tip: If your IP changes frequently, the wildcard % can save you from having to update it every time.
How to enable remote access in DirectAdmin ⚙️
-
🔑 Log into your DirectAdmin panel.
-
📋 Go to Account Manager > MySQL Management.
-
📂 Select the desired database.
-
🌐 Under Access Hosts, add the external IP you will connect from.
-
➕ Click Add New.
📌 Note: Repeat this process for each database you want to grant access to.
Additional recommendations 🧠
-
🧰 Use tools like MySQL Workbench or Toad for more comfortable management.
-
🔒 Avoid the wildcard
%if not necessary, for security reasons. -
📁 Protect your credentials and do not share them.
Need help? 🤝
If something is not working or you have questions, our support team is ready to help. Write to us anytime! 📩