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)