MySQL password change - by mistake (without using WHERE)

  • thin_phone
  • Newbie
  • Newbie
  • thin_phone
  • Posts: 5

Post 3+ Months Ago

Have just done something REALLY stupid.

I just ran the following query WITHOUT including the WHERE statement:
UPDATE mysql.user SET password=password("mypassword")

I then closed the database program. As this is a new server i dont have a backup of the database before. Is there any way to undo this?
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2194
  • Loc: Canada

Post 3+ Months Ago

Contact your server admin and ask if he has a recent backup.
  • Daemonguy
  • Moderator
  • Web Master
  • User avatar
  • Posts: 2700
  • Loc: Somewhere outside the box in Sarasota, FL.

Post 3+ Months Ago

http://www.debian-administration.org/articles/442

Try that... saving access to root... wow.
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2194
  • Loc: Canada

Post 3+ Months Ago

I'm not sure if that's what he's looking for - by my reading, I understood that he changed every users password to "mypassword".

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 4 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.