Error establishing a database connection on hosted site running SimpleScripts

  • Resolved matteo85

    (@matteo85)


    14 years, 7 months ago

    I see that many users get the following error…:

    Error establishing a database connection

    along with the standard reasons why; i.e. the “3 questions”. I also notice that some replies are rather stupid, such as, “the error gave you your answer.”

    Let me assure you that, yes, I have the correct username and password; yes, I have typed the correct hostname, and yes, the database server is running.

    I am running off a hosted site at BlueHost.com. They have a SimpleScript installation feature that works seamlessly every time. However, when I try to install manually, I *invariably* get the above mentioned error. No help is forthcoming from BlueHost’s technical support team.

    I need to be able to install the database and use custom table prefixes for each installation of WP on the site.

    I anyone has any experience with BlueHost, or a similar situation, I welcome your comments, but please, don’t just reply with the same old trite answers that I have seen on other posts re: this problem.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Brian Harris

    (@zgani)

    14 years, 7 months ago

    If you have created the database and username and connected the two with the correct privaleges and the hostname is indeed correct then you shouldn’t be getting such an error.

    cPanel appends your username at the begining of the database name and username. Again if you entered the name as displayed in your MySQL in the cPanel then there should be no error, but if you’ve only entered the name as you created it then that will result in the error mentioned.

    Thread Starter matteo85

    (@matteo85)

    14 years, 7 months ago

    For some reason, deleting the user and then re-establishing the user seems to clear up the problem. I don’t know why this is the case since I verified the UN, PW and DB names in the wp-config.php file and in the cPanel.

    CLOSED.

    Yes, cPanel does append the site/database/username to the front of the db name, ex: sitename_username is what is given for the user, sitename_databasename for the database, etc. If you are experiencing this error, make sure you include the pre-appendage to the name, or the connection won’t work. This wasn’t the problem here, but there you go.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error establishing a database connection on hosted site running SimpleScripts’ is closed to new replies.