Installation, Error establishing…!, MySQL 4.1.7

  • To all those having problems installing WordPress on your own Windows 2000 (and other Win OS versions) workstation – and maybe some host servers, too: Do not use MySQL 4.1.7 – it is the problem if you get “Error establishing a database connection!”. It does not seem compatible with the other components. Use MYSQL 4.0.22 instead. Podz, you may want to take note of this solution and make a statement somewhere on the web site…
    Thanks to the Reply by ADAMANT in response to the POST of Nov 6, 2004 02:21:29 by ANTOINE, the WordPress installation really did become only 5 minutes, after two days of frustration:
    I started with Windows 2000, PHP 4.3.9, Apache 1.3.33 and MySQL 4.1.7. I spent two days checking my wp-config.php literally 100 times; making changes; troubleshooting my database, using every known name for my host (localhost, 127.0.0.1, <IP address>, computer name, etc…) to no avail. I kept getting:
    “Error establishing a database connection!” …
    I knew it wasn’t my config. So thanks to ADAMANT’s suggestion, I uninstalled MySQL 4.1.7 and downloaded and installed MySQL 4.0.22 from mysql.org. After installing and configuring the new (old) MySQL, which took approximately 7 minutes (very easy), I ran the install.php once again and YES!! it actually took less than 5 minutes for the WordPress install.
    NOTE: the Apache web site says NOT to use Apache 2 in production. So, after all my wasted time with the latest MySQL, I suggest the following to those who can control their environment:
    PHP 4.3.9, Apache 1.3.33 and MySQL 4.0.22. On Windows at least, they all work well together.
    Steven
    [email protected]

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

  • Thanks for the post, and yes I’ll see that get’s placed where it can be useful.

    It’s in Codex, with two questions from the FAQ linking to it.
    Thanks again!

    Thread Starter Anonymous

    This is the fix… When you create a new db user you must set the password MANUALLY… This is a clip from the mySQL manual…
    To change the password but create a short hash, use the OLD_PASSWORD() function instead:
    mysql> SET PASSWORD FOR ‘some_user’@’some_host’ = OLD_PASSWORD(‘mypass’);
    It now works like a charm for me… ??

    I had problems as well, even with the previous ‘fix’. MySQL crashed when installing. The best bet is to roll back to 4.0

    I agree, make sure you use the recommended version of MySQL, not the latest one. I installed on a Mac, and it took me a long time to figure out that my MySQL was too recent a version, and downgrading it fixed everything.

    Here’s my site: Sprocket ??

    Alex

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Installation, Error establishing…!, MySQL 4.1.7’ is closed to new replies.