Step 1: Enter the Database
If you don’t have your database credentials you can certainly grab them from your wp-config.php file, usually located in /var/www/html. Copy your username and password, you’ll need these to enter phpMyAdmin.
/** MySQL database username */
define('DB_USER', 'yourusername');
/** MySQL database password */
define('DB_PASSWORD', 'userpassword');
Visit https://yourhostname.com/phpmyadmin (or http) and enter your database username and password from your wp-config.php. Click on your database name on the left, in this case, ours is named 929368_kittens.
Note
If you do not find a phpMyAdmin login page when going to the previously mentioned URL, check with your Admin or support team as it may be at a particular URL.
Step 2: Edit your Database
Find the wp_users table and click the Edit link in the same row as the user’s email address.
Step 3: Edit A User’s Email

Step 4: Change A User’s Password
In the user_pass row set the new password by replacing the previous password with a new one. Choose MD5 from the drop-down box and select Go.
