Home‎ > ‎DBA Stuff‎ > ‎MySql‎ > ‎

Reset Password


Procedures: 

login to mysql, and reset password: 
sudo su -
/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root

Enter in the following in the mysql prompt: 
use mysql;
update user set password=PASSWORD("DSxdWXdyCBB7") where User='root';
flush privileges;
quit


Restart the services with the new password: 
/etc/init.d/mysqld stop
/etc/init.d/mysqld start

Example: 



Comments