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...

Over 20000 Satisfied Customers!

  • web hosting reviewer
    Valerie Quinn
    CTO, Acteon Group

    Centriohost staff were fantastic, I had a concern with a domain and they got back to me very quickly and they helped me to resolve the issue! ~ . . . Read more

  • Joomla hosting reviewer
    Collin Bryan
    Photographer, Allister Freeman

    I'm using centrio for my portfolio since 2006. The transition was seamless, the support was immediate, and everything works perfectly. ~ . . . Read more

  • dedicated server reviewer
    Harry Collett
    Actor, A&J Artists

    Very easy to understand & use even though I am not very technologically minded. No complications whatsoever & I wouldn't hesitate to recommend it to all. ~ . . . Read more

  • vps web hosting reviewer
    Porfirio Santos
    Technician, Diageo PLC

    Centrio support team have been amazingly responsive and helpful to any of my queries, thank you so much to the Centriohost have been amazingly responsive and helpful to any of my queries 👍👍👍 ~ . . . Read more

  • wordpress hosting plans reviewer
    Catherine Auer
    Doctor, SmartClinics

    Anytime I've had a problem I can't solve, I've found Centriohost to be diligent and persistent. They simply won't let an issue go until the client is happy. ~ . . . Read more

  • reseller hosting reviewer
    Effectivo Social
    Freelancer, Fiverr

    Recommend their shared hosting for all my SME web design clients. Their cloud or VME offerings are too great to deal with. Pricing is perfect and suitable for all users (͠≖ ͜ʖ͠≖) 👌 ~ . . . Read more