ABHIONLINUX
Site useful for linux administration and web hosting

2009/09/13

How to reset mysql password

Login to mysql safe mode

mysqld_safe --skip-grant-tables &

Change the MySQL admin(root) Password using following command

mysql>update user set Password = Password('pass') where User ='root';

Flush the privileges so everything will take (It removes any
privileges set by the server)

mysql>flush privileges;

mysql>quit

Stop MySQL Service


----------
kill -9 pid [to kill a process]
killall -9 mysql

No comments:

Post a Comment