WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Cannot Connect To MySQL (Yet Another! Sorry!) (8 posts)

  1. RickSanson
    Member
    Posted 8 years 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!

  2. moshu
    Member
    Posted 8 years ago #

    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?

  3. RickSanson
    Member
    Posted 8 years ago #

    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!

  4. MichaelH
    Member
    Posted 8 years ago #

    Firewall?

  5. Ryan
    Member
    Posted 8 years ago #

    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.

  6. RickSanson
    Member
    Posted 8 years ago #

    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!

  7. RickSanson
    Member
    Posted 8 years ago #

    Good News!

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

    Thanks to all!

  8. vkaryl
    Member
    Posted 8 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic