Title: Login Problem
Last modified: August 18, 2016

---

# Login Problem

 *  Resolved [rcmullins](https://wordpress.org/support/users/rcmullins/)
 * (@rcmullins)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/login-problem-3/)
 * I have a unique problem. I was messing around with MySQL and decided to try changing
   my admin login password using MySQL. Here is the query I used.
    UPDATE wp_users
   SET user_pass = PASSWORD(‘mypass’) WHERE ID = 1;
 * It worked beautifully. Only problem is, that I cannot login now. I am using wordpress
   on the standard apache 2, php5, MySQL 5 set up. Anybody have any ideas on how
   to get around this? (BTW the PASSWORD(‘mypass’) part allows the password to be
   hashed.) I have tried changing the password to not hash but this doesnt work 
   either. I also have the mail settings turned off, so my password cannot be emailed
   to me. I looked through the php_login.php page and I cant seem to sort out how
   the login page is passing the password into MySQL so I can login.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/login-problem-3/#post-367016)
 * update your wp-config.php file to use the new password?
 *  Thread Starter [rcmullins](https://wordpress.org/support/users/rcmullins/)
 * (@rcmullins)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/login-problem-3/#post-367048)
 * Well, I didnt change the password to the DB. I changed the admin password to 
   get into wordpress, but i did it using sql query through the mysql, using a hash.
   Maybe im not being very clear?
 *  Thread Starter [rcmullins](https://wordpress.org/support/users/rcmullins/)
 * (@rcmullins)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/login-problem-3/#post-367104)
 * HandySolo: I figured out a way to do it, without using the phpMyAdmin thing. 
   Using a sql command you can hash using the MD5 hashing algorithm. Its really 
   quite easy too. Thanks to you for pointing me in the right direction. Here is
   the query.
 * UPDATE wp_users SET user_pass = MD5(‘mypass’) WHERE ID = 1;
 * For anyone out there here is how it works.
 * You log into your wordpress database within MySQL. There are several ways to 
   do this, using the commanline or the new MySQL query analyzer. The password and
   user information is located in the table wp_users. Once you are ‘using’ the correct
   database you just execute the above command/query. Since all the admin stuff 
   is located in id# 1 the only thing you will have to alter is the ‘mypass’ part.
   Just fill in your desired password, and you should be set.
 * Anybody who needs more explanation on this, please feel free to email me at;
   
   [rcmullins@centurytel.net](https://wordpress.org/support/topic/login-problem-3/rcmullins@centurytel.net?output_format=md)
   It may take me a day to get to you, but I will try to respond the best way I 
   know how.
 * Thanks again to HandySolo for helpin meh.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Login Problem’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [password](https://wordpress.org/support/topic-tag/password/)
 * [passwords](https://wordpress.org/support/topic-tag/passwords/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [rcmullins](https://wordpress.org/support/users/rcmullins/)
 * Last activity: [20 years, 2 months ago](https://wordpress.org/support/topic/login-problem-3/#post-367104)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics