I have problems accessing my MySQL database remotely

If you have problems accessing your database at your web hosting account remotely please make sure that:

  • You are using the correct MySQL hostname – it should be yourdomain.com or your server's name;
  • You are using the correct MySQL database / username / password. 
  • Don't forget to specify your MySQL username and database with the prefix yourusername_ in front of its given name. For example, your cPanel username is whnetwork and you have named your database joomla. In this case you have to refer to your database as whnetwork_joomla
  • You have allowed the remote host to access your database. This can be done from your cPanel > Remote MySQL.
  • You are connecting to the TCP port 3306.

A common mistake is to try accessing your databases using the main cPanel login. This will not work and you have to use the MySQL user instead.

If you are having problems accessing your MySQL databases remotely, please submit a ticket to support department for assistance.

  • 116 Users Found This Useful
這篇文章有幫助嗎?

相關文章

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database.  1) Through...

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...