Results 1 to 1 of 1
# The root access is mandatory
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 ...
- 09-02-2008 #1Linux Newbie
- Join Date
- Apr 2008
- Location
- India
- Posts
- 170
[SOLVED] Changing or resting MYSQL passord when lost
# The root access is mandatory
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)
flush privileges;
6.quit
service mysqld restart
Now try login to mysql with new pass .....!!Regards
David.s
davidanands.co.cc
-->Success is the list of failures ...!!!


