Error establishing a database connection

  • Resolved shrapnel

    (@shrapnel)


    18 years ago

    well the so called five minute install is now at two days…

    Still staring at “Error establishing a database connection”

    let’s take it one step at a time.

    Are you sure you have the correct username and password?

    Yes.

    Are you sure that you have typed the correct hostname?

    definitely

    Are you sure that the database server is running?

    quite sure

    I found a “common troubleshooting hint” here:

    I keep getting an Error connecting to database message but I’m sure my configuration is correct.
    Try resetting your MySQL password manually. If you have access to MySQL via shell, try issuing:

    SET PASSWORD FOR ‘wordpressusername’@’hostname’ = OLD_PASSWORD(‘password’);

    when I execute this (with of course the appropriate fields filled in) I get this error:

    ERROR 1133 (42000): Can’t find any matching row in the user table

    This makes no sense, however, as the user is created and I can login to mysql at the command line by doing mysql -u -user -p database

    oh grumpy day. who will brighten my cheeks with joy?

    S

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

    (@poetics5)

    hey bro – do a google for mysql old_password.
    chage the $value to = your_value
    UPDATE mysql.user SET Password = OLD_PASSWORD(‘$userpascode’) WHERE Host = ‘$host’ AND User = ‘$user’; FLUSH PRIVILEGES;

    if you have sqlyog you can just run it as a query – thats what i do, so maybe it’ll work in a script.

    also i normally run it as so:

    UPDATE mysql.user SET Password = OLD_PASSWORD(‘$userpascode’) WHERE User = ‘$user’; FLUSH PRIVILEGES;

    i do that because i control my db and it only has users i setup for apps. also since apps may be on this server or another one i give them both local and remote access, so removing the host param lets me update both the local and remote account at the same time.

    cheers hope it helps

    vkaryl

    (@vkaryl)

    If that doesn’t work for you, and you’re still thinking it’s something with the password, here’s a tutorial on resetting the password in the database table itself:

    https://www.tamba2.org.uk/wordpress/phpmyadmin/

    Wonder if this is a related problem. I’ve had WP set up for ages. Everything worked fine. Until today, when I started getting this same error message. Wp-config hasn’t changed. there is no .htaccess set for the directory, and the one at the root directory is empty. The hosting company (bluehost, since wp recommended it) has no idea what’s happening. They tried resyncing the DB a couple times, which worked for a little while, but the problem started again soon after.

    I updated WP to the latest edition and went into the server to kill all processes, but I’m still getting this error. Anyone have any idea what’s up?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error establishing a database connection’ is closed to new replies.