Error connecting to DB when configuring WordPress

  • Resolved jnl2

    (@jnl2)


    10 years, 7 months ago

    Background

    Personal: Just a long time PC user with some DB courses completed. This is my first time running my own server and database.

    OS: MS Windows 7 (current updates)

    SERVER (local): WAMP stack installed and running (i.e. able to access the phpMyAdmin page, add DBs and Users)

    WordPress: recent version installed. DB and User created as per instructions on Codex.Wordpress.org (https://codex.wordpress.org/Installing_WordPress#Using_phpMyAdmin#Using_phpMyAdmin)

    —-

    When trying to configure WordPress via the page: http://localhost/wordpress/wp-admin/setup-config.php, after entering the requested information DB (db_wordpress), User (user_wordpress), Password, DB Host (tried both localhost or mysql wampserver), the following page states that there is an error in connecting to the DB.

    I’ve also tried manually modifying the www/wamp/wordpress/wp-config-sample.php file (re-naming it wp-config.php with the same information provided above and then loading localhost/wordpress/, the result, an error message informing me that it can not connect to the database.

    Any ideas?

    Thanks everyone.

Viewing 3 replies - 1 through 3 (of 3 total)
  • ashiquzzaman

    (@ashiquzzaman)

    10 years, 7 months ago

    Did you tried deleting the WordPress database from mySQL and recreating a fresh new one and then install WordPress ?

    Dion

    (@diondesigns)

    10 years, 7 months ago

    Did you tried deleting the WordPress database from mySQL and recreating a fresh new one and then install WordPress?

    That would serve no purpose whatsoever. Anyway…

    In most cases this is due to either the MySQL user not having the correct privileges, or the version of WAMP requires that you specify port 3306.

    If you use the root user/password in wp-config.php, does WordPress load? If not, then change DB_HOST in wp-config.php from localhost to localhost:3306 and see if it works. If that doesn’t work, then check the MySQL logs — there should be something listed to help you locate the problem.

    If the root user worked, then go to the Users page in phpMyAdmin. Make sure the user has full access (not just USAGE) to the specified database, and also make sure the user has host access to localhost and 127.0.0.1. That should be enough to get you working.

    Thread Starter jnl2

    (@jnl2)

    10 years, 7 months ago

    Thanks for those responses.

    I tried the suggestions posted by Dion, unfortunately they did not let me get past WP’s configuration page (http://localhost/wordpress/wp-admin/setup-config.php).

    Then I went back to the phpMyAdmin page, removed the DB and User created for WP and began trying different permentations of creating the user/db that would allow me to proceed past the …/setup-config.php page.

    In the spirit of adding what I learned and that worked, I’ll post it here.

    When creating a new user/db combination on the create new user page in phpMyAdmin the default Host value type is Any Host which was left unchanged in previous unsuccessful attempts. In a recent attempt, the Host type was changed to Local and the following field was changed to Localhost. (The properly filled out phpMyAdmin/users page is displayed here )

    This new variant allowed me to successfully complete the …/setup-config.php page (configuring WP and creating a wp-config.php file) and move to creating my first WP project. No doubt that approach would have seemed obvious to a seasoned WAMP/AMP server guru but for this newbie, it was a learning experience that will be shared for other newbs.

    Cheers.

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

The topic ‘Error connecting to DB when configuring WordPress’ is closed to new replies.