Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Wordpress Passwort reset ====== mysql -u root -p #(Logs in to MySQL/MariaDB) Enter your password at the prompt. use name-of-database #(Selects your WordPress database) show tables LIKE '%users'; #(Finds the WordPress user table) SELECT ID, user_login, user_pass FROM name-of-table-you-found WHERE user_login = 'username'; # (Observe the encrypted password) UPDATE name-of-table-you-found SET user_pass=MD5('new-unencrypted-password') WHERE user_login = 'username'; # (Updates the database with the encrypted password) SELECT ID, user_login, user_pass FROM name-of-table-you-found WHERE user_login = 'username'; # (Confirm that it was changed) exit # (Exits the MySQL client) computer/wordpress/wordpress_password_reset.txt Last modified: 2025/03/02 14:08by spring