Error establishing a database connection

  • The title is the error I’m getting.

    A mysql upgrade on the server somehow deleted all the database user/passwords. I made a new user with the same user/pass as in wp-config.php and then I added the user to the database but wordpress is still broken.

    Any suggestions?

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

  • Start with a new database. Add a new username and no password (later you’ll add one, lets just get it connecting first.) A place to get help is the irc for wordpress too.

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

    Thread Starter junglecat

    (@junglecat)

    Samboll the problem is not the admin account. Take a look:
    https://www.stopanimalid.org/blog/

    What happened was, mysql went down on the server and wouldn’t come back up. I rebooted mysql several times and no help. The data center’s solution was to upgrade mysql, and when they did, all the database user/passwords on the server got deleted. I got the forums, shopping carts, etc back up by recreating the users using the same user/pass as were in the clients’config files, but this one blog didn’t connect after I recreated the user.

    usermac, do I just create a blank database with no tables in the control panel?

    I have my own server so I have root server access if there is anything in there I can do.

    I also am having the same problem accessing my blog.
    I tried the above recommendations and still not able to see the blog. Other blogs on the same server are OK. Tried changing password in phpAdmin and in wp-config. Any more ideas? Could it have been an hacker?

    junglecat – yes to ‘create a blank database with no tables…’.

    I had the admin password reset through the backend, MySQL command used –
    UPDATE user_login SET password = MD5( ‘NmCeUDTf’ ) WHERE ID =1 LIMIT 1

    Thread Starter junglecat

    (@junglecat)

    usermac, I created a blank database, what next?

    waltbren, I tried your solution and got the error:
    MySQL said:

    #1146 – Table ‘stopanim_wrdp1.user_login’ doesn’t exist

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

Tags