MYSQL

Change WordPress password directly in database

June 16, 2026June 7, 2024 by piroman

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 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 of the … Read moreChange WordPress password directly in database

June 16, 2026April 23, 2022 by piroman

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 database.name 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