Cannot Connect To MySQL (Yet Another! Sorry!)

  • Resolved ricksanson

    (@ricksanson)


    19 years, 3 months ago

    Hi All!

    I’ve googled and searched but no answer yet…

    Am getting the apparently typical message while attempting to install WordPress; “Error Establishing a Database Connection”

    Specifics are:

    Self hosted on RedHat Enterprise Linux ES 3.4
    MySQL version 4.1.16-Max
    PHP version 4.3.2
    Wordpress 1.5.2

    This is a fresh install
    The database is up and verified by both command-line and phpMyAdmin. Am not using MySQLi but have reset all passwords to the older hash mechanism as well as starting MySQL using the -oldpassword switch. I can login to MySQL as both root and the “wordpress” user.

    The database has been created and wp-config.php certainly looks correct. Please see below;

    ?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘blog’); // The name of the database
    define(‘DB_USER’, ‘wordpress’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘xxxxx’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

    Any assistance is appreciated!

    Thank you!

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

  • I am not a server guru and we don’t really provide support for learning how to set up a server. (Before you disagree… 99.99% percent of self hosting install problems come form not proper server setup!)
    Does the user “wordpress” has all the privileges?

    Thread Starter ricksanson

    (@ricksanson)

    Thanks for the quick response…

    First, yes, user “wordpress” has all privileges.

    Not to sound self-serving but I do have a fair amount of experience with these things so I wouldn’t characterize myself a newbie. But definately a newbie to WordPress…

    Could I have a funky server setup? Possibly but I am using this same MySQL for another applicaiton which runs fine…

    Any other ideas???

    Thank you!

    Firewall?

    Do you have root access where you could try to login to MySQL directly? Or, via one of the 3rd party programs?

    A problem I’ve had a few times has something to do with how passwords are stored for MySQL. Twice I’ve had to use the old_password function in an SQL query to get a WordPress blog working. Although, I think this is specific to a MySQL version rather than WordPress.

    Thread Starter ricksanson

    (@ricksanson)

    Thanks All!
    +++++
    “Firewall?”

    Nope, I own it and am behind it…

    +++++
    “Do you have root access where you could try to login to MySQL directly? Or, via one of the 3rd party programs?”

    I can do both! I am using the native MySql utilities and phpMyAdmin.

    I have reverted to the old_password hashing and can successfully (locally) log into MySql as the wordpress user. Like I say, this server is using this installation og MySql for another application that work properly. I’m doubting MySql is the issue but won’t rule out anything.

    I’m into page 24 (again) of this installation support and am yet to uncover anything…

    Thank you!

    Thread Starter ricksanson

    (@ricksanson)

    Good News!

    I entered the private IP address and the thing worked. I guess I am one of the 1%…

    Thanks to all!

    That’s great, RickSanson! Can we take it that this means “resolved”? If so, could you change the dropdown above to reflect that, please and thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Cannot Connect To MySQL (Yet Another! Sorry!)’ is closed to new replies.