MYSQL

Change WordPress password directly in database

June 7, 2024June 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’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

January 25, 2024April 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