08-25-2020, 07:10 AM
##First you need to have database access, if you forgot username and password then you can get it from /path_to_directory/wordpress/wp-config.php
## then follow these steps
echo -n "newpass" | md5sum
mysql -u root -p
MariaDB [(none)]> show databases;
MariaDB [(none)]> use wordpress;
MariaDB [(none)]> show tables;
MariaDB [(none)]> SELECT ID, user_login, user_pass FROM wp_users;
MariaDB [(none)]> UPDATE wp_users SET user_pass= "e6053eb8d35e02ae40beeeacef203c1a" WHERE ID = 1;
MariaDB [(none)]> UPDATE wp_users SET user_pass = MD5('the_new_password') WHERE ID=1;
MariaDB [(none)]> SELECT ID, user_login, user_pass FROM wp_users WHERE ID = 1;
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit;
##All done!
## then follow these steps
echo -n "newpass" | md5sum
mysql -u root -p
MariaDB [(none)]> show databases;
MariaDB [(none)]> use wordpress;
MariaDB [(none)]> show tables;
MariaDB [(none)]> SELECT ID, user_login, user_pass FROM wp_users;
MariaDB [(none)]> UPDATE wp_users SET user_pass= "e6053eb8d35e02ae40beeeacef203c1a" WHERE ID = 1;
MariaDB [(none)]> UPDATE wp_users SET user_pass = MD5('the_new_password') WHERE ID=1;
MariaDB [(none)]> SELECT ID, user_login, user_pass FROM wp_users WHERE ID = 1;
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit;
##All done!