Error establishing Database Connection

  • Resolved alexcrockett

    (@alexcrockett)


    15 years, 1 month ago

    Dear anyone who can help,

    I just installed XAMPP onto my computer (running windows XP). It’s running fine, I created a database for WP, added a user etc etc.

    I then extracted the WP files, changed the WP-Config destails and that’s where I’m now stuck. I get an error message trying to open the install file to run the installation. I have tried changing user to root, password to empty, host to the IP of the host and a series of other suggestion.

    A MAC user seemed to resolve the problem by putting the location of their port in WP-config. Someone else wrote that they had to give MYSQL the command:

    SET PASSWORD FOR some_user@some_host = OLD_PASSWORD(‘some_password’)

    and this also seemed to work for a few people. I have no idea what this actually means or if it’s relevant but I’m just including to show that I’m not being lazy, I am trying to figure this out. Any help would be very welcome.

    TY – for any help you can give!

    A

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter alexcrockett

    (@alexcrockett)

    I should add that I did check the password and other information quite a few times. Just because I wanted to be absolutely sure it wasn’t me I even deleted everything and started again from scratch!

    Thread Starter alexcrockett

    (@alexcrockett)

    I resolved the problem quite easily if anyone is interested.

    First, I created a new database.
    Second, created a new user.
    Third I noticed that the initial user I created was registered under ‘Local’ as opposed to ‘Localhost’ so I changed this in phpmyadmin and oila, it worked.

    So I guess my problem was that when i set up the user I had followed the instructions that I had, however the host on wp-config and on my wp database were not the same.

    @alexcrockett, good call–worked for me, too. Thank you!

    Just tried it. Didn’t work for ;( I also have confirmed all my passwords. So just want to make sure I understand… on the wp-config.php doc you changed the wording from ‘localhost’ to ‘local’ right?

    Moderator James Huff

    (@macmanx)

    That may not work for all hosting providers and servers. You should probably confirm it with your hosting provider first.

    I had the same problem and was able to fix it by changing localhost to 127.0.0.1 in the wp-config file.

    Hope this helps someone.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error establishing Database Connection’ is closed to new replies.