Can’t access MySQL DB to install

  • Resolved nulldogmas

    (@nulldogmas)


    17 years, 1 month ago

    I’m trying to do a WordPress install on panix.com, and my WP keeps telling me it can’t access the MySQL server:

    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 mysql2.ivy-prep.com.

    I have the correct login and password in the wp-config.php file, and the hostname is what Panix gave me. I’ve confirmed that Panix is running MySQL 4 or greater (5.0.26, actually). Running mysql from the command line with these parameters works fine – WordPress, however, doesn’t seem able to see the DB server.

    Any suggestions how to troubleshoot this? I’m out of ideas.

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

  • Most of the time an error like that does mean you’ve not got the correct values in wp-config.php or you’ve got an extra space in a ‘definition’, for example:

    define('DB_HOST', ' mysql2.ivy-prep.com');
    is not the same as:
    define('DB_HOST', 'mysql2.ivy-prep.com');

    Also, the DB_USER you are using may not have all rights to the database.

    I had to set up a database through the control panel.Then I forgot one thing. I emailed the webhost and received this reply:
    “there was one step missing – clicking on the ‘Add User to Database’ button”

    Ah, yeah. You need to add a user to each database that you create.

    Thread Starter nulldogmas

    (@nulldogmas)

    I’ve triple-checked wp-config.php, and there are no stray spaces. And a user was created by Panix – it can access MySQL from the command line, so that’s not the problem. It’s only WordPress that can’t see the DB for some reason.

    Thread Starter nulldogmas

    (@nulldogmas)

    Going once, going twice… Any ideas for trying to diagnose this before I go tell my client she needs to get a new webhost?

    journalist setting up wp for a “client”, suggesting a new web host. ok. ??

    wordpress is hardly ever wrong (IF ever) when it spits out from the wp-config.php. Thats one of the nearly fool-proof thngs it does. I have $100.00 that says its not a host issue. It’s a user issue.

    Thread Starter nulldogmas

    (@nulldogmas)

    As it turns out, in this case you’d lose. After a week of back and forth, Panix tech support finally informed me:

    The issue appears to be that the in-apache php module on our shared servers is compiled against a very old version of mysql.

    They’re going to work on upgrading, but it’s likely to take a week or more.

    So what’ll it be, whooami, check or PayPal…?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Can’t access MySQL DB to install’ is closed to new replies.

Tags