• Sorry to be asking this again, I know its been asked many times, but I’ve read dozens of other posts and I think I’m doing everything right.

    Here’s what I’ve done:

    Copying localhost site from XP machine to Windows 8.1 Machine
    New WAMP Server on Win 8.1 Machine
    Copied old wordpress subdirectory into new WAMP www subdirectory
    Exported database from old machine with PHPMyAdmin
    Create new Database same name in new machine with new PHPMyAdmin
    Imported old database into new machine successfully
    No change in host, user, name, password, so no reason for wp-config to be changed.
    Browser to localhost/sitename and I get the “Error Establishing Database Connection” error.

    What magic step am I missing?

Viewing 8 replies - 1 through 8 (of 8 total)
  • What you have done looks correct, but obviously isn’t 🙂

    Were you using the WAMP default database user and password on the XP system? That is, root and empty (no password), OR did you create your own database user on the XP system? If so, you will have to do the same on the 8.1 db as well.

    Thread Starter djmiller78

    (@djmiller78)

    Thank you for responding.

    I didn’t create a new database user.

    I am installing WAMP 2.5, the old installation was WAMP 2.2

    I’m also seeing a PHP error log filled up with these warnings:

    [15-Feb-2015 11:37:54 UTC] PHP Warning: PHP Startup: Unable to load dynamic library ‘c:/wamp/bin/php/php5.5.12/ext/php_intl.dll’ – The specified module could not be found.

    That subdirectory is in place and so are all the files the log complains about.

    A couple things:

    – is the WAMP system tray icon ‘green’

    – are you able to successfully see the WAMP start page when you enter http://localhost

    Thread Starter djmiller78

    (@djmiller78)

    Yes, W is green and online, and yes I have access to all localhost utilities.

    The only thing that I can suggest is to ‘triple check’ the values in your wp-config. Something is not correct in either the values there or the db name in the 8.1 db. As you probably know, all it takes is a space in one of the values to generate that error 🙂

    Thread Starter djmiller78

    (@djmiller78)

    I’ve tried the raw and generated passwords from the wp_users password
    database variable in the wp-config file and neither work. The password
    works fine in the old machine / database.

    I suspect that would generate a password error anyway, not a database connection error.

    Other than that, everything looks fine. I appreciate your time and effort Lyle. Let me know if any other ideas come to mind. I may try installing the older version of WAMP, but I’m afraid that would create a new nest of issues with Win 8.1.

    I’ve tried the raw and generated passwords from the wp_users password
    database variable in the wp-config file and neither work

    The values in the wp_user table are for the WordPress login, and NOT for the database 🙂

    Given the name of the database is wordpress, this is what your wp-config should look like:

    /** The name of the database for WordPress */
    define('DB_NAME', 'wordpress');
    
    /** MySQL database username */
    define('DB_USER', 'root');
    
    /** MySQL database password */
    define('DB_PASSWORD', '');
    
    /** MySQL hostname */
    define('DB_HOST', 'localhost');
    Thread Starter djmiller78

    (@djmiller78)

    Brilliant!

    Thank you for enlightening me to that subtle fact that should be obvious!

    I don’t know how its working in the old machine, but that’s OK, its
    working in the new machine now!

    Have a great day!

    Dave Miller

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

The topic ‘New local WAMP Machine Error Establishing database connection’ is closed to new replies.