ANOTHER "Error establishing a database connection"

  • GracieA

    (@graciea)


    10 years, 7 months ago

    [do publish your personal information]

    I’ve never successfully used WordPress – tried in the past, and ran into so many of this kind of error, I quit. Trying again…….

    I figure there have to be a ton of topics that resolve this but I’ve been looking around for just over 3 hours now, and I’m not seeing anything that fixes my problem.

    Local install on PC running Windows 10.

    I got the wamp server running after chasing around for an hour to get apache to work.

    I got into the mysql piece and created:
    database – “xyz”
    user – “xyz”
    password – “xyz”
    host – “localhost”

    which SEEMS to simple it would be IMPOSSIBLE to screw up… I can create a TABLE and a COLUMN and run SQL to insert records. So the database is apparently up and working………

    Go back to localhost/wordpress and it wants me to provide the database, user, password, and host – simple enough and hard to screw up… So, I do. All lower case, just like above (I even did a snip to put the picture in here, but can’t see how)…

    And, I get the “Error establishing a database connection” and no wp-config file…….. So, I take the SAMPLE wp-config and change the user, password, database info in there and create my OWN wp-config:

    define(‘DB_NAME’, ‘xyz’);
    /** MySQL database username */
    define(‘DB_USER’, ‘xyz’);
    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘xyz’);
    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    Touched NOTHING else in the entire file.

    Back to Firefox. Entered localhost/wordpress and got the SAME error.

    WHAT do I need to do to get this product INSTALLED correctly?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Clayton James

    (@claytonjames)

    10 years, 7 months ago

    Did you give the user you created permissions on the database you created for wordpress?

    mysql -u root -p

CREATE DATABASE database_name;

CREATE USER wordpressuser@localhost;

SET PASSWORD FOR wordpressuser@localhost= PASSWORD("password");

GRANT ALL PRIVILEGES ON database_name.* TO wordpressuser@localhost IDENTIFIED BY 'password';

FLUSH PRIVILEGES;
    SMblogger

    (@smblogger)

    10 years, 7 months ago

    Can I add my challenge? I installed MAMP and set up a database named “erwinsco”. using the wp tool, I provide the following:

    database: erwinsco
    user: root
    password: root
    server: localhost

    get the “Error establishing a database connection” message.

    Nothing in the videos stated that I need to do more than just create a db on MyPHPadmin. I am not well knowledgable about MySQL. But I did try manually entering the credentials in the sample config file and renaming it wp-config.php

    What else can I do to resolve this? Ive confirmed that the database is there (myPHPadmin). Ive confirmed that MAMP is running. Ive confirmed that the wordpress folder I extracted and renamed is in the htdocs folder (made no changes to folder configuration)

    Would greatly appreciate ANY help.

    Clayton James

    (@claytonjames)

    10 years, 7 months ago

    @smblogger

    You should start your own thread. MAMP and WAMP are two different animals. While the WordPress install procedure is identical, it’s bad form to hijack someone elses topic.

    Some reference material and links that might help:
    http://codex.ww.wp.xz.cn/Common_WordPress_Errors#Error_Establishing_Database_Connection

    http://codex.ww.wp.xz.cn/Installing_WordPress#Local_Installation_Instructions

    http://codex.ww.wp.xz.cn/Installing_WordPress_Locally_on_Your_Mac_With_MAMP

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

The topic ‘ANOTHER "Error establishing a database connection"’ is closed to new replies.