How to reset wordpress user password using mysql

login to the mysql
#mysql -u -p

/*use wordpress site database*/

mysql> show databases;

mysql>use ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

/*show database tables */

mysql>show tables;

/*show users list */

mysql> SELECT ID, user_login, user_pass FROM wp_users;

/* To change user password please use one of below methods */

/*Method -1: if you already converted password in md5*/

mysql> UPDATE wp_users SET user_pass=’db6f6da1ce3437f3d38eb05a63402d41′ WHERE ID = ‘1’;

/*Method -2: if you want to supply plain text passwrod */

mysql> UPDATE wp_users SET user_pass=md5(‘plain text password’) WHERE ID = ‘1’;

🙂

Different remedies existing from the Web to why to waste time and visit dispensary if you can easily purchase medications sit at home. There are numerous of legal online drugstores that will deliver remedies to your home. If you are considering Cialis, you probably want to study more about Cialis. (See also Amoxicillin Over the Counter). This website provides you with some useful information on the benefits of remedies and how they are evaluated for safeness. Generally, both men and women are afflicted by sexual disorders. Often, when humanity think about Cialis, they mean Generic Amoxil Amoxicillin. The very momentous question you must look for is Cialis. (Read more Other Forms of Metronidazole). Finally, such kind of difficulties can be an early warning symptom of serious heartiness problems, such as heart disease. Finally ordering remedies online can save money, but keep these tips in mind.