Rest your MySQL Admin Password
From Brian Nelson Ramblings
Revision as of 15:13, 15 November 2013 by Brian (Talk | contribs) (Created page with "===How to reset your MySQL Admin Password=== You have installed MySQL and now you are having a hard time remembering the password, what should we do? Lets reset the MySQL ro...")
Contents
How to reset your MySQL Admin Password
You have installed MySQL and now you are having a hard time remembering the password, what should we do? Lets reset the MySQL root password.
You will need to login as the root user
First: Need to stop MySQL
/etc/init.d/mysql stop
or
killall mysql
Second: Create a msyql password sql script
vim /root/mysql.reset.sql
Append the following code:
UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root'; FLUSH PRIVILEGES;
Save and close the file
Third: Set the new mysql root password
mysqld_safe --init-file=/root/mysql.reset.sql &
Output should be:
nohup: ignoring input and redirecting stderr to stdout Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[20970]: started
And now you are done resetting the mysql root password
Now simply stop and restart mysql
killall mysqld /etc/init.d/mysql start