{{parent page="Mysql"}}

===Resetting Mysql root password===
Mysql password can be reset by
	1) Shutdown mysql
	1) Start mysql with a special option **safe_mysqld --skip-grant-tables**
	1) Login to mysql and update the user table **UPDATE user SET password=null WHERE Host='localhost' AND User='root';**
	1) Shutdown mysql
	1) Startup mysql normally
	1) Change the root password by **mysqladmin -uroot password 'new-password'**

===Resetting mysql user password===
%%
mysql> set password = password("yournewpassword"); 
%%

===Another way===
http://code.openark.org/blog/mysql/dangers-of-skip-grant-tables