another “error establishing Database connection” issue

  • jakender

    (@jakender)


    17 years, 3 months ago

    OK, Here’s the scenario. I have multiple WP installs on my VPS account on several different domains. All the existing ones are working fine. I’ve tried to set up a couple new ones in the last few days, have quadruple checked the info in the wp-config.php for both, and both get the same “Error Establishing a Database Connection” page (generated by WP) that tells me to check password/etc.

    I’ve even gone so far as to SSH to the command line on the server and connect to mysql with the login info in the wp-config.php (which works). My server is using an older version of MySQL and PHP (not sure which ones exactly, but I can look it up if it might help), but again, they’re perfectly functional for the existing blogs using 2.7.1 and it’s just the attempts to create a new one that are failing. Anything jump out at anybody?

    Oh, I’ve also restarted the MySQL daemon on the server through WHM, and tried changing localhost to the IP addresses for the server.

Viewing 10 replies - 1 through 10 (of 10 total)
  • figaro

    (@figaro)

    17 years, 3 months ago

    See if this helps:

    http://educhalk.org/blog/?p=148

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    Thanks figaro… alas I had already started there before posting. no luck (that’s where I got the idea to try changing localhost to IP even though my existing installs were still working with localhost). Good video BTW.

    My VPS provider was in the box earlier this week to reboot things and clean up an inode problem. I’m wondering if they tweaked something at that time, nothing they’ve admitted to yet, but I’m hunting.

    figaro

    (@figaro)

    17 years, 3 months ago

    even though my existing installs were still working with localhost

    If your existing installs work with localhost, then this one should as well.

    I know you said you checked everything, but if you have existing installs on that account that work, then this one should as well…I would still look at the other variables in the wp-config.php file…one of them must be wrong IF other existing installs work. If you have another working install, compare the connection information in that config.php file with this one…it could be something as small as a missing single quote ‘ from one of the variables.

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    Gone through them many, many (frustrating) times. Also tried it on the two domains to make sure it wasn’t just the one (and started clean each time), compared to existing working config.php as well (only diff being dbname, username, pword which were verified via command line mysql). Have alternately granted “ALL” permissions to the usernames, and individually selected all permissions for them.

    Do you know if there is a setting somewhere that would turn on a more meaningful error (pass a direct MySQL error number maybe)?

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    I don’t see them mentioned in the quick-install instructions, but the config.php has an area for “Authentication Unique Keys” are those now required?

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    Oh, also tried it with a copy of the 2.6 files I still had as well , to no avail.

    oh, and.

    mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline 5.1

    PHP 4.4.8

    Thanks for the help so far BTW (have also double checked files again, and tried with and without the AUTH items defined)

    figaro

    (@figaro)

    17 years, 3 months ago

    You have my interest. If you would like to contact me offline, with the login to your control panel an phpMyAdmin, I’ll see if I can help. My email is 234figaro432 [at] gmail [dot] com

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    figaro and I have had no luck. Everything looks good in the files. Waiting on word from VPS provider on what they might have done.

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    Provider fixed it with no explanation. Waiting on word back and hoping for an explanation.

    Thread Starter jakender

    (@jakender)

    17 years, 3 months ago

    “compiled MySQL again into PHP.”

    Thanks again to figaro for the help.

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

The topic ‘another “error establishing Database connection” issue’ is closed to new replies.