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
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
Maria DB 10 is only alpha software. As such it is indeed a brave person who installs it on a live box!"I used to be with it, then they changed what it was.
Now what was it isn't it, and what is it is weird and scary to me.
It'll happen to you too."
The Fifth Continent
- 05-17-2013 #5