Archive

Do you support remote MySQL connections?

Yes, remote MySQL connections are enabled.

If you are trying to connect to the MySQL server from a remote location (e.g. your computer), use your hosting account IP address as the MySQL hostname. Your server IP address can by found on the left hand column when you login to cPanel. Do not forget to add your computer IP address to the ‘cPanel’ -> ‘Remote MySQL’ section.

get ‘access denied’ errors when trying to connect to MySQL

If you cannot connect to the MySQL server, this might happen due to several reasons:
– Incorrect MySQL hostname.
The MySQL hostname on most of our servers is localhost (with the exception on few reseller servers). You can always double check this information in your Members area -> List accounts -> Account details.

– Incorrect MySQL username / password or database name.
Please navigate to cPanel -> MySQL to check this information. If you cannot remember what password is set on the MySQL user, feel free to delete it and recreate it one more time.

– You have not added the MySQL user to the database.
This is a very common issue that people forget to do. In order to have a fully operational MySQL database you must also add a MySQL user to the MySQL database and assign full permissions. You can achieve this by clicking on the ‘Add’ button under ‘cPanel’ -> ‘MySQL Databases’ -> ‘Add User To Database’ section.
If you have any other issues with the MySQL connection after taking these steps, please let us know.

What is your MySQL hostname?

The MySQL hostname on most of our servers is localhost (with the exception on few reseller servers). You can always double check this information in your Members area -> List accounts -> Account details.
If you are trying to connect to MySQL from a remote location (for example from your computer), please use these instructions:
– Use the IP address of your hosting account as your MySQL hostname. Your IP address can by found on the left hand column when you login to cPanel.
– Please add your computer IP address to the cPanel -> Remote MySQL section. You can check the computer IP address at http://www.tracemyip.org/
– Use either the MYSQL username / password that was created in cPanel -> MYSQL section, or your cPanel login details to connect to the database.