Results 1 to 1 of 1
Enjoy an ad free experience by logging in. Not a member yet? Register.
- Join Date
- Apr 2008
[SOLVED] Changing or resting MYSQL passord when lost
Just follow the steps to reset the mysql password
1.login as root
2.service mysqld stop //stop mysql
3./usr/bin/safe_mysqld -Sg & // restart safe_mysqld with the skip-grant-tables option
4.get into mysql as mysql -u root -p or (mysql -u root -p mysql)
when promoted for password press enter
5.copy the code
update user set password=password("new_pass") where user='root'; (change new_password with you new desired password)
service mysqld restart
Now try login to mysql with new pass .....!!Regards
-->Success is the list of failures ...!!!