Question
WordPress not recognising admin password it was set up with.
- Posted on November 9, 2019
- WordPressApacheUbuntu 18.04
Asked by Illusive
After setup finished I attempted logging into my WP admin acount. wp-login.php page doesn’t load at all, or when it does password is “incorrect”, except it isn’t. Password is literally the same as it was during initial configuration. Tried “restoring password” (predictably it didn’t work), rebooting vps and even deleting and creating new droplet (to be fully sure, that WP is installed correctly). Even skipped certbot step (still wasn’t working when I used it so not big loss). I can access droplet via console though (hooray!).
What is interesting is that this issue seems to be affecting only website/droplet created after the recent "support portal “crash”.
Sometimes even the text-only default WP website won’t load or load but extremely slowly. Both issues are tested on Firefox, Chrome and Opera mobile. Wi-Fi and mobile 4G internet. Connection quality seems to be random. Login denial is permanent.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hello, @Illusive
Have you tried to manually change the password from the database itself? If you’ve installed phpMyAdmin you can change the password from there or do it manually from the command line as well:
You can reset the password from phpMyAdmin using the following steps:
-
Access phpMyAdmin in your browser
-
Click on the name of your WordPress database.
-
Next click on the wpusers table. (your database might have different prefix, e.g jpipousers, but you still need to access the _users table)
-
Click on Edit beside your WordPress admin user.
-
In the user_pass field, paste your password by pressing Ctrl – V and from the drop-down, select MD5. Finally click on Go. You should now see a success message from phpMyAdmin saying the database record was updated.
You can do this manually via the command line:
- Access mysql as root:
mysql -u root
- List your databases:
show databases;
- Select your database:
use yourdatabasename;
- List the database tables:
show tables;
- Update the password using this query:
UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';
Keep in mind that if you have different prefix for the database you will need to change wp_users to match your database prefix. Once this is done you should be able to access your database.
Let me know how it goes.
Regards, Alex
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.