Error establishing a database connection with Charter Business hosting

  • Resolved doorcowebie

    (@doorcowebie)


    13 years, 11 months ago

    Hello everyone,

    We’ve recently been working on redesigning a website for one of our clients in WordPress. I’ve been working on the proof of their site through our HostGator account/server and we are ready to move it over to the client’s host (Charter Business). I’ve had no issues with the site on our server and transferred all the files over the the client’s server. The new database is set up and the data has been imported from our site through phpmyadmin into the database.

    The trouble I’m running into is that I’m getting the Error establishing a database connection message. Here is the complete message:

    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?

    I checked my wp-config.php file a couple times and the hostname, username and password are exactly as what is given to me in the Charter Business database setup:

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘dbyyyyy_xxxx’);

    /** MySQL database username */
    define(‘DB_USER’, ‘uyyyyy_xxxx’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘*********’);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    I’ve tried the hostname as localhost, and also tried the one provided in the database setup: mysql52int.cp.charter-business.net. I tried allowing access to external hosts and it gives me an ip address to use. None of these have worked to connect to the database.

    Is anyone else using the Charter Business hosting for their WordPress site and if so, have you been successful in getting WordPress connected to your database? Is there anything else I should look for or try to get the connection working?

    Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)

  • Have you tried checking the port that the connection is using?

    Thread Starter doorcowebie

    (@doorcowebie)

    I had not previously but when I looked back under the Charter database control panel, here is some of the info they provided:
    Database name dbyyyyyy_xxxxxx
    Database type MySQL
    Status Ready
    Internal hostname mysql52int.cp.charter-business.net
    Host port 3306
    Access from external hosts Disabled

    I called Charter tech support a couple times and they didn’t have any ideas and told me to submitted a support ticket to them, which I’ve done.

    hostgator use a localhost and have you tried and changed localhost to mysql52int.cp.charter-business.net in wp-config.php

    Thread Starter doorcowebie

    (@doorcowebie)

    Yes, I tried both localhost and mysql52int.cp.charter-business.net for the db_host.

    I had no issues with getting wordpress to connect when it was under our HostGator account/database – it is just the connection with our client’s Charter mysql database.

    Then only host can help you may be there some other setting as they can log in check it out

    Thread Starter doorcowebie

    (@doorcowebie)

    It ended up being an issue with the client’s Charter hosting account. They were on an old hosting platform and we were told wouldn’t be migrated to the newer platform anytime soon. The client contacted Charter and threatened to discontinue their services with them so Charter eventually migrated them to the new hosting and the site is up and running without any database connection issues.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error establishing a database connection with Charter Business hosting’ is closed to new replies.