bspacer1 bspacer2
webmail hosting forum clients about

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98
Home PagePortal HomeClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloadsRegister

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > I have problems accessing my MySQL database remotely

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;

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 pjrsales and you have named your database joomla. In this case you have to refer to your database as pjrsales_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.



Was this answer helpful?

Add to Favourites
Print this Article

Also Read
How can I import a large database to my account? PhpMyAdmin times out. (Views: 11279)
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)
I get syntax error when trying to run a MySQL query. (Views: 1061)
I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)
My application cannot connect to my database. (Views: 5027)

Powered by WHMCompleteSolution


Copyright © 1994-2021 PJR Sales and Service All Rights Reserved