• As have others (most recently, dtclarinet; tfrederick), I have put Strayhorn on the my server, revised the config script according to directions, and gotten the error, “Error establishing a database connection.” I’ve done a lot of checking to no apparent avail.

    Environment: Mac OS X 10.3.8, Apache 1.3.33, PHP 4.3.10 (yes, functioning), mysql 4.1.10-standard (yes, functioning).

    Partioning the error, here’s what I’ve tested:
    <ol><li> Confirmed that the DB_NAME, DB_USER, and DB_PASSWORD exist and the spellings in mysql and config.php are the same.</li>
    <li>
    Confirmed that the DB_USER can log into mysql using DB_PASSWORD and has been granted permissions to write to the DB_NAME.</li>
    <li>
    Altered the identity of the DB_HOST to the name for the server, https://name.for.server, and etc.</li> </ol>

    I’m managing everything pretty-much manually (not by GUIs), so I don’t think there’s any funky interactions between WP or my server and some intermediary application.

    So, I’m stuck. Suggestions?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Take the https:// off the server name, maybe?

    Thread Starter JohnL

    (@johnl)

    Right. Tried it both ways. I also specified the port 3036.

    Thanks, though.

    Try this thread, fixed my problem having to do with using MySQL 4.1 and up.

    https://www.ads-software.com/support/topic.php?id=20783#post-118725

    Thread Starter JohnL

    (@johnl)

    Thanks, Charles.

    I’d looked at that thread previously (last night?) and dismissed it because of the recommendation that one upgrade 4.3.9; I’m already at 4.3.10. Anyway, I dropped mysql_error() into the wp-db script and reran the install script, but to no avail. The script simply repeated the error page generated by the function and didn’t report an error. (Perhaps I put the command in the wrong place?)

    So, I’m still going in circles. Sigh.

    did you add:

    If you get the above MYSQL error then you can fix this by doing logging into mysql and do the following:

    SET PASSWORD FOR ‘user’@’localhost’ =
    OLD_PASSWORD(‘password’);

    That is what finally did it for me.

    Thread Starter JohnL

    (@johnl)

    Charles, thanks for persistence. I had not issued the mysql commands. I logged into mysql as root, issued the command, and ran the install script. That change accomplished the proverbial trick. I now see the page generated for the first step.

    Thanks again,

    JohnL

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘More on installation failure’ is closed to new replies.