Revision [3496]
Last edited on 2009-08-20 02:36:24 by WikiAdminAdditions:
===Another way===
http://code.openark.org/blog/mysql/dangers-of-skip-grant-tables
http://code.openark.org/blog/mysql/dangers-of-skip-grant-tables
Revision [1806]
Edited on 2008-07-14 00:21:11 by WikiAdminAdditions:
===Resetting mysql user password===
%%
mysql> set password = password("yournewpassword");
%%
%%
mysql> set password = password("yournewpassword");
%%
Revision [610]
Edited on 2007-05-29 02:29:35 by WikiAdminAdditions:
1) Login to mysql and update the user table **UPDATE user SET password=null WHERE Host='localhost' AND User='root';**
1) Startup mysql normally
1) Change the root password by **mysqladmin -uroot password 'new-password'**
1) Startup mysql normally
1) Change the root password by **mysqladmin -uroot password 'new-password'**
Deletions:
%%
UPDATE user SET Password=PASSWORD('YOUR_PASSWORD')
WHERE Host='localhost' AND User='root';
%%
Revision [609]
Edited on 2007-05-29 02:00:18 by WikiAdminAdditions:
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 manually
1) Shutdown mysql
1) Start mysql with a special option **safe_mysqld --skip-grant-tables**
1) Login to mysql and update the user table manually
Deletions:
1) Start mysql with a special option **safe_mysqld --skip-grant-tables**
1) Login to mysql and update the user table manually
Revision [608]
Edited on 2007-05-29 01:59:49 by WikiAdminNo differences.
