WordPress.org

Ready to get started?Download WordPress

Forums

Error establishing a database connection (7 posts)

  1. paulkiser
    Member
    Posted 1 year ago #

    I've edited wp-config with the correct username, password, hostname, etc, and still get this 'Error establishing a database connection'. I've read many forums for solutions, but nothing has worked so far. Changed hostname to 127.0.0.1, doesn't work. I did the oldpassword sql thing to no avail. Does WordPress append characters to the front or rear the the database name I supply, could it be looking for a database name with appended characters, maybe "wp_" or something. I am trying to install on my local host. Using Apache software to develop and test dynamic web pages, but can't get the WordPress to install. Please tell me what I am doing wrong or where I can find the correct database name, userid, password, etc. that WordPress is expecting. I am quite sure I have spelled them correctly in wp-config.

  2. Bharat Tekwani
    Member
    Posted 1 year ago #

    The database name should be localhost and not the ip address. I could be wrong though just check it out.

    how did you create database and user?

  3. Dion Hulse
    WordPress Dev
    Posted 1 year ago #

    Make sure the database which you're putting in the install page actually exists - WordPress doesn't attempt to create the database itself, only the tables within.

    Does WordPress append characters to the front or rear the the database name I supply, could it be looking for a database name with appended characters, maybe "wp_" or something.

    No, It uses it just as you supply it.

    I'd suggest attempting to connect with PHPMyAdmin or similar to make sure the details (and database listed) are correct.

  4. WebHosting Watch
    Member
    Posted 1 year ago #

    Make sure that your database has all the necessary permissions via your hosting control panel.In case the login details in your wp.config file are 100% identical with the database user and password details set by you while adding your db in your control panel, try to run grant all command to set all the db permissions.

    If this won't help, try to import the database latest dump via PHPMyadmin.

  5. paulkiser
    Member
    Posted 1 year ago #

    I created the database in PHPMyadmin with the name 'wordperss', is this a bad name, does it confuse WordPress. It was suggested by the tutorial in Dreamweaver that I was going by, also in the WordPress install documentation. Username me, 'paulkiser' was added with all privileges on the 'wordpress' database. It has 0 tables in it. The install documentation didn't say anything about adding tables, yet. When I bring up the page in PHPmyadmin 'Users having access to 'wordpress' database it lists the user 'paulkiser' and 'root', under the 'Host' heading for 'root' it lists 'Linux' and 'localhost', for 'paulkiser' under 'Host' it lists '%', is this a problem, why doesn't it have 'localhost' for me also, could this be my problem, it so how do I get PHPMyAdmin to put 'localhost' as my host? I can see how this may confuse WordPress, but I don't know any way to get 'localhost' in there. Any suggestions.

  6. paulkiser
    Member
    Posted 1 year ago #

    Have a typo in there. Created database name is 'wordpress' not 'wordperss'.

  7. jetwu
    Member
    Posted 1 year ago #

    Hi all,
    I also have a similar situation, I am using local host to create my website, the whole site almost finish, but suddenly the website appear "Error establishing a database connection", I try to access the admin Control Panel, below is the page info:

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the tsc database.

    Are you sure it exists?
    Does the user root have permission to use the tsc database?
    On some systems the name of your database is prefixed with your username, so it would be like username_tsc. Could that be the problem?

    Is it means my database is not exist any more? and need to re-build the whole website again??

    I don't know what happen and how to recover it?

    any friend can help me?

    Thank you in advanced!

Topic Closed

This topic has been closed to new replies.

About this Topic