CODEWITHSUNDEEP
mysql
Arunjith
Arunjith

Reputation: 131

Recover MySQL root Password

We can reset the mysql password by using the mysqld_safe with --skip-grant-tables option.

  1. Can we reset it without mysql restart?
  2. Can we recover the password instead of Resetting ?

Upvotes: 7

Views: 2680

Answers (4)

Richard Scott Smith
Richard Scott Smith

Reputation: 1

This is documented in the Official MySQL documentation here: https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

I doubt this won't address any and all concerns because you can basically fix any permission or user problem with this method.

Upvotes: -1

mykey
mykey

Reputation: 575

  1. stop mysql service and start it in safe mode
  2. start mysqld --skip-grant-tables
  3. change password normally

see also [1]: http://www.debian-administration.org/articles/442

Upvotes: 1

piotrm
piotrm

Reputation: 12356

1) You can update user table in mysql database but only if you still have active connection with enough privileges.

2) You cannot, passwords are not stored, only their hash values, on your login hash of your password is compared to hash stored in mysql and there is no way to find password out of hash other than trying all possible passwords hoping for hash match.

Upvotes: 1

anubhava
anubhava

Reputation: 784918

  1. No
  2. No

And there is good reason of both No answers.

  1. You can't just let any non-root user reset your root password without having full admin level access to the MySQL process on that host.
  2. MySQL passwords (like Unix passwords) encryption is 1 way street, they can be reset but cannot be decrypted back.

Upvotes: 6

Related Questions