Robot Portal

Easily manage all aspects of your account | Knowledgebase |

Knowledgebase

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.

  • 35 Users Found This Useful

Was this answer helpful?

Related Articles

Stats not updating!

We allow our customers to update the stat by themselves. So login to your AWSTATS and click on...

HTTP Error Codes !

400 Bad Request The user’s request contains incorrect syntax. 401 Unauthorized The requested...

How can I login into cPanel / WHM / Webmail?

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

Do you support GD & ImageMagick?

Yes, we do support GD & ImageMagick modules across all our servers. The module-binaries are...

What's the Hostname & Port for MySQL?

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

  Tag Cloud

Born in 2004 ... Trusted By Clients n' Experts

SEO Stars

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Read More

Emily Schneller Manager at Sabre Inc
SEO Stars

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

Read More

Leena Mäkinen Creative producer
SEO Stars

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

Read More

Ziff Davis CEO at Mashable
SEO Stars

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

Read More

Isaac H. Entrepreneur
SEO Stars

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

Read More

Madeline E. Internet Professional