Change WordPress password directly in database

If you are stupid enough, as I am, you will need to do this. Yes, my WordPress couldn’t send an email to reset my password and I’ve forgot it. Long story short, I had to change it, without PhpMyAdmin since I’m using a self hosted WP. First, I had to find the name od the … Read moreChange WordPress password directly in database


Login: List databases: Delete database: Make new database: List users: Make new user: Delete user: Gives all rights to user over a certain database (replace with * for all databases): Refreshes privileges, a must after a change: Lists user rights: Exports (dumps) the database: Shows original (exported) database name: Imports dump of some database … Read moreMYSQL

Tested on Ubuntu & Pop OS