Irtaza Tech Blog - Web Hosting | Scripting | Web Design

Follow the below steps to easily reset the root database password even if you have lost it:

1) Stop Mysql

service mysqld stop

2) Run mysql in safe mode.

mysqld_safe --skip-grant-tables &

3) Now you can login to mysql with no password

mysql -uroot mysql

4) To reset mysql root password use the following command.

user mysql;
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;
quit;


At this time your root password is reset to “abcd” and MySQL will now
know the privileges and you’ll be able to login with your new password:

5) Now restart mysql service

service mysqld restart

now you can use your mysql with new password
mysql -uroot -pabcd mysql

No related posts.