Donate with
Categories
Donate with
82uymVXLkvVbB4c4JpTd1tYm1yj1cKPKR2wqmw3XF8YXKTmY7JrTriP4pVwp2EJYBnCFdXhLq4zfFA6ic7VAWCFX5wfQbCC
Wordpress :: Reset Administrator (root) Password directly on the MySQL Database using PHPMyAdmin
Donate with
82uymVXLkvVbB4c4JpTd1tYm1yj1cKPKR2wqmw3XF8YXKTmY7JrTriP4pVwp2EJYBnCFdXhLq4zfFA6ic7VAWCFX5wfQbCC
Howto Reset WordPress Administrator Password using a database tool like PHPMyAdmin
Why do I want to do this?
Because you forgot the password or maybe you want to continue developing a page that was originally developed by someone else and now nobody knows the password to the admin account anymore.
Howto
- Log into the DB administrating tool of your choice. We use PHPMyAdmin for this.
- Select the database and locate the "users" table. Usually it has a prefix like "wp_" and thus is called "wp_users":
- Click on that users table
- Now PHPMyAdmin fetches a list of users. You'll see the usernames in the column called user_login like this:
- Remember the username that seems to be the admin account for this WordPress setup
- Change to the "SQL" Tab like so:
- With the query you see in the above screenshot you can reset the password to '12345'. No need for typing, you can copy/paste it from here:
update wp_users set user_pass=MD5('123456') where user_login='admin_user'; - Check out you set the parameter "wp_users" and "admin_user" according to your WordPress setup / user name
- That's it. Just leave a comment (or two) if it doesn't work for you.