Results 1 to 5 of 5
There has been a recent problem with our server's DBAs and we lost control of the root password. The DBAs tables are safe as they can make backups with their ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 05-13-2013 #1
[MySQL] Reset root password or delete ALL databases
There has been a recent problem with our server's DBAs and we lost control of the root password. The DBAs tables are safe as they can make backups with their own users, but the "root" user currently has an unknown password.
Is there a way to edit a file like you can for UNIX passwords (in /etc/shadow) to reset the MySQL root password?
Otherwise, is there a way to dump ALL tables, to be able to remove the MySQL package and then make a clean installation in which the DBAs can reimplement their backups?
- 05-13-2013 #2
No need for such a drastic method.
You can shut down mysql and then reset the root pw with:
mysqld_safe --skip-grant-tables & mysql -u root use mysql update user set password=PASSWORD("NewPassword") where User='root'; flush privileges; quitYou must always face the curtain with a bow.
- 05-13-2013 #3
- 05-17-2013 #4
- 05-17-2013 #5