{{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