Thursday, November 4, 2010

How to change admin password in the table of the mysql database?

■ Requirement : How to change admin password in the table of the mysql database
■ OS Environment : Linux[RHEL, Centos]
■ Application: mysql
■ Implementation Steps : 


mysql> update agb_book_auth set password=MD5("newwpass") where username="admin";

Where table agb_book_auth contains admin and password attributes.

OR :

mysql> update wp_users set user_pass = 'b15a2021cb835426552c5d8599d5c7ab' where user_login = 'admin';
mysql> flush privileges;


No comments:

Post a Comment