Mysql password issues

  • Resolved CallMeAndy

    (@callmeandy)


    8 years, 10 months ago

    So I am using Hostgator, recently was hacked and fixing issues gradually, anyway I wanted to make sure the database was tight. Went onto my CPanel and changed the password associated the with the only user registered to have DB permissions (DB_PASSWORD), expecting to having to change wp-config thereafter, so the two would be in synch!

    However after the change I browsed to the site expecting it to fail and it didnt. I login to admin – no barrier!

    Thought I would try remoting in with MySql Workbench – sure enough it didnt like the password after prompting for one, but expecting to get denied access to the database, inspite of being refused, it allowed access to the data. Whatsmore it also allows seemingly full rights, or at least as regards editing data.

    Ive changed again to make sure I didnt mug the process but sure enough the same results.

    Its probably something so fundamental but what am I overlooking? Or is this not the problem I think it is?

    Thanks
    Andy

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

    (@macmanx)

    Perhaps check with Hostgator, you might be changing it on the wrong user or the change just isn’t going through, because other wise it just doesn’t make sense. WordPress will use the password in wp-config.php, and if it doesn’t match, all you’ll see on your site is “error establishing database connection.”

    Thread Starter CallMeAndy

    (@callmeandy)

    Thanks James – I knew it wasn’t making sense that’s why I posted the question. Of course it was me being a dick and only pressing a Generate New Password button, without pressing the Set Password button thereafter.

    Moderator James Huff

    (@macmanx)

    You’re welcome!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Mysql password issues’ is closed to new replies.