Allow update without ftp login – Add these two lines to the bottom of the wp-config.php file:
/* Allows update without login */
Update WordPress Password with MariaDB/MySQL:
WARNING: If you do not specify which row you are updating you will change the password for all users!
1. Open up your wp_users table and identify the ID associated with the user_name you need to modify.
2. Run SQL (where 99 represents the ID of the user !USE the correct ID!):
UPDATE wp_users SET user_pass = MD5(‘thePassword’) WHERE I =99;