Can I Access MySQL Remotely? Remote Database Connection Explained

Method 1: phpMyAdmin (Recommended)

phpMyAdmin is a web-based database management tool built into cPanel. It provides a full graphical interface for managing your MySQL databases.

Steps to Access phpMyAdmin

1. Log in to cPanel (yourdomain.com/cpanel)
2. Scroll to the Databases section
3. Click phpMyAdmin
4. Select the database you want to manage from the left sidebar

What You Can Do in phpMyAdmin

• Browse and search data in your tables
• Run SQL queries — Execute custom queries, imports, and exports
• Import databases — Upload .sql files to restore or migrate data
• Export databases — Download your database as a .sql backup
• Create and modify tables — Add columns, change data types, set indexes
• Manage users — View and update database user privileges

Method 2: Command Line via SSH

If your hosting plan includes SSH access:

1. Connect to your server via SSH (using PuTTY or Terminal)
2. Run the MySQL command-line client:

mysql -u yourdbusername -p yourdatabasename

1. Enter your database password when prompted
2. You now have full command-line access to your database

Method 3: SSH Tunnel (Advanced)

If you need to connect a local application (e.g., MySQL Workbench, DBeaver) to your hosting database, you can use an SSH tunnel to create a secure connection:

1. Open your database client (e.g., MySQL Workbench)
2. Create a new connection with these settings:

1. Connect — the SSH tunnel encrypts the connection and bypasses the remote MySQL restriction

Note: SSH access must be enabled on your hosting plan. Not all shared hosting plans include SSH. Contact Cynet support to check or enable it.

If your application requires a direct remote database connection (e.g., an external app, API, or service connecting to your database), shared hosting is not suitable. Consider:

• VPS Hosting — Full root access with the ability to configure MySQL to accept remote connections securely
• Cloud Hosting — Scalable resources with configurable firewall and database access rules

Can I whitelist my IP for remote MySQL access?

Remote MySQL access is not available on shared hosting plans, even with IP whitelisting. Use phpMyAdmin or an SSH tunnel instead.

My application needs to connect to the database — will it work?

If your application (WordPress, PHP site, etc.) is hosted on the same server, it connects to MySQL via localhost — this works normally and is not affected by the remote access restriction. The restriction only applies to connections from external computers or servers.

Can I import a large database?

phpMyAdmin has an upload limit (usually 50–100 MB). For larger databases:

1. Upload the .sql file to your hosting via FTP
2. Use SSH to import it: mysql -u username -p database_name < /path/to/file.sql
3. Or contact Cynet support for assistance with large database imports