How to Reset the Root Password in MySql Database
Mar 1, 2021
Run the following commands separately to change/reset your ‘root’ user password in MySql database.
There is a database called mysql
which is the default database. It is where Users such as root
are stored. More info can be found
In this script, it is assumed that your new password is MyNewPassword
. Hence, replace that with whatever you want your password to be.
UPDATE mysql.user
SET Password=PASSWORD(‘MyNewPassword’)
WHERE User=’root’;FLUSH PRIVILEGES;
Originally published at http://binyit.blogspot.com.