Easiest way to this is by using PhpMyAdmin, a web-based software that allows you to manage MySQL databases using your web browser. It offers an interface that allows you to run MySQL commands and database operations. It’s typically made available by the hosting services provider.
Once you have access, you’ll see a display of all tables in your WordPress database, which contains important settings. You need to be extremely careful when using PhpMyAdmin, or you may end up accidentally deleting important data.
Select the wp_users table, view table data, and edit the user that requires a password change. Delete the value under user_pass and enter the new password. Under the function column, select MD5 from the drop-down menu and Save.
Congratulations! You have successfully changed WordPress user password using PhpMyAdmin.