Results 1 to 5 of 5
Enjoy an ad free experience by logging in. Not a member yet? Register.
[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?
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.
Maria DB 10 is only alpha software. As such it is indeed a brave person who installs it on a live box!Should you be sitting wondering,
Which Batman is the best,
There's only one true answer my friend,
It's Adam Bloody West!
The Fifth Continent