RSS

MySQL Connection problem

Tue, Dec 2, 2008

Featured

This issue is already resolved. MySQL database host is set to the default “localhost”.

For those clients using our old hosting plans that having problem in connecting to thier database using “localhost” as database host, please open ticket to our support [support@philhosting.net]



our Linux MySQL servers has been successfully moved to our new grid servers. This updates will have minor changes with the database host.

For Linux hosting clients who having MySQL connection problem in their web application, you need to update your MySQL host in your site settings:

1. For clients using Linux Value, Minipack, old Linux Basic plans, please update your database host

from localhostto db.value.http.ph“.

2. For clients using Linux Professional, Enterprise,old Linux Advance plans, please update your database host

from localhostto db.advanced.http.ph.


For clients who use Wordpress, please edit your wp-config.php file which is usually found in the main folder where Wordpress is installed.


Find this line below:

define('DB_HOST', 'localhost');

delete the localhost and enter the database host provided above

e.g.  define('DB_HOST', 'db.value.http.ph');

For clients who use Joomla, please edit your configuration.php file which is usually found in the main folder where Joomla is installed.


Find this line below:

$mosConfig_host = 'localhost';

delete the localhost and enter the database host provided above

e.g.  $mosConfig_host = 'db.value.http.ph';


26 Comments For This Post

  1. Xandrouz Says:

    I already changed the host from “localhost” to “db.value.http.ph” but still it’s not working. Im using zencart.

  2. nursepod Says:

    I suggest that you should have a step by step guide in doing this.

  3. Root Says:

    Xandrouz:
    ===========================================
    Please login to your account cPanel, go to then add access host “value.http.ph” or “%”.

  4. Ervin Says:

    My joomla application can’t connect to the database. What do I need to make this work?

  5. Allan Says:

    It still not working even I changed localhost to db.value.http.ph or db.advanced.http.ph in my wp-config.php

  6. Allan Says:

    Darn… please add in your article that you need to reset your MySQL login info. coz what I did is to delete my old login info and add it again.

    Hope this will help for all

  7. killervinz Says:

    i Guess your right., we need step by step guidelines to make this change succesful. im using joomla., but still i cant surf my /administrator

  8. Simon Says:

    I’ve just changed it, and still experiencing database error

  9. Tam Says:

    It is important to know your configuration script,where script to database is connecting.

    1. For clients using Linux Value, Minipack, old Linux Basic plans, please update your database host

    from “localhost” to “db.value.http.ph“.

    2. For clients using Linux Professional, Enterprise,old Linux Advance plans, please update your database host

    from “localhost” to “db.advanced.http.ph“.

    Access your cpanel, then add “%” to your remote mysql

  10. Siege Says:

    I’ve done what you suggested, and I still run into this problem often. Please help.

  11. Rex Says:

    It seems like the ‘new’ database servers don’t have my recent data! What happened?!

  12. phreakerzoid Says:

    Remote administration is not working for MySQL using SQLyog Community Edition with the new server settings even adding my ip address on the remote administration tab on the Linux cpanel.

  13. Jowy Says:

    Step-by-step please!

  14. Ant Says:

    My access host includes those values, but I still get an error.

  15. bleue Says:

    I tried replacing the entry in my wp_config.php from localhost to ‘localhost’ to ‘db.advanced.http.ph’ since I am under Linux Professional plan and it didn’t work (Error establishing database connection), I also tried ‘db.value.http.ph’ but to no avail. I reverted it to localhost for the mean time, it is up now but with a VERY SLOOOOOOOW response. What should I do?

  16. rayve Says:

    Yeah i figured out what happen, but i have another concern, sometimes the cpanel is out of reach. Is there any problem? Or cpanel is affected by the upgrades?

    Thanks!

  17. Rommel Says:

    Bakit ganun napalitan ko na ung localhost sa db.value.http.ph nag error connection pero nung binalik ka sa localhost gumana pero sobrang tagal mag load ng website ko….. please help naman dyan bumagsak ang visiors ko sa websote ko….

  18. bleue Says:

    I tried replacing the entry in my wp_config.php from localhost to ‘db.advanced.http.ph’ since I am under Linux Professional plan and it didn’t work (Error establishing database connection), I also tried ‘db.value.http.ph’ but to no avail. I reverted it to localhost for the mean time, it is up now but with a VERY SLOOOOOOOW response. What should I do?

  19. vince Says:

    Please make your instructions clearer. You must understand that not all your clients are professional web masters. I do suggest that you try to make a step by step instructions on how are we going to update our sites. My site has been down for more than a week. And this is the only time that i have read this instruction.

    I do hope that next time you will make a timely note about any problems, and a more detailed instruction to help your clients.

    Please post a more specific instruction on where we can find this “Data base Host”. I can’t see it. And I don’t know where to click, was it in “MySQL”? Now you see… it’s a little complicated for us because we are not that professional in website making.. though trying. Be a little help naman po.

    Thanks.

  20. keithmaxx Says:

    I can’t even access my cPanel. So how can my webspace installation get fixed? I already have tickets filed but no one’s answering my concerns properly.

  21. keithmaxx Says:

    I tried doing these changes on my Wordpress installation but then it got completely broken looking for functions that worked fine before trying this. What’s happening?

  22. ramonitom Says:

    hi,

    i’ve got the same problem with clients who are using joomla. i can’t even access the joomla admin.

    please help in all your capacity. like any other, am not a website master.

  23. Mark Says:

    is this related?

    Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance.

    having problems on my supposed to be new website…

  24. Ace Says:

    Hi author,

    I tried connecting remotely using my user@domain.com:3306 before and it was working fine but now with the new configuration, I am unable to connect.

    What’s the value for “Server Host” if I will be connecting remotely? eg. MySQL Query Browser, SQLYog.

    Any answer yet?

    Thanks!

  25. Root Says:

    Hi Ace, MySQL remote access is forbidden due to user abuse. If you want to have MySQL remote access, send a request to our support with your IP address and account information.
    NOTE: We only allow up to 5 IP address for client to avoid network congestion that affects other clients.

    If you don’t know your IP address, just simply fo to http://www.whatismyip.com

  26. Stonedeft Says:

    How about in a vbulletin board how do you do this? I don’t want to run a fresh install of the app