I have problems accessing my mysql database remotely

If you have problems accessing your database 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. Make sure you have followed right steps for creating them; 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 siteground and you have named your database joomla. In this case you have to refer to your database as siteground_joomla; You have allowed the remote host to access your database. This can be done from your Cpanel, Mysql, “Allowed hosts” at the bottom of the page. Cpanel does not allow any hosts to access your database by any means; 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?

 Print this Article

Also Read

What's the Hostname & Port for MySQL?

When configuring any of your scripts on the server, use the following connection info to connect...

How can I enable Mod-Rewrite Module?

In order to enable Mod_Rewrite for your site you should create a text file called .htacccess in...

How can I login into cPanel / WHM / Webmail?

You can login to cPanel by : http://cpanel.yourdomain.com http://yourdomain.com:2082...

How to provide WHM/Master Reseller with Zamfoo Panel?

If you have Master/Alpha Reseller account with ZinkHost, do the following to give WHM Panel to...

How do I configure my desktop's mail client with an email account?

A mail client is an application you use to check your email. The mail client can be either web...

Powered by WHMCompleteSolution