Step 1: Identify the user id for which you want to change the password

Step 2: Issue the below MySQL command to update the password for the selected user

update wpgi_users set user_pass=MD5(‘yourpasswordgoeshere’) where wpgi_users.id=1