I've done it so many times at this point that I need to write it down!
When I create a local copy of a site and copy/paste the live files to my local machine, I often forget not to copy/paste the wp-config.php.
So...the db access get's overwritten.
Then I try to go into phpmyadmin on Xampp (ServerPress) and inevitably set a password on the root user like a dumbass and lock myself out of phpmyadmin completely.
So to save myself 45 minutes trying to figure out how to get back in the next time this happens (likely a month from now!). I'm writing this down.
1.
Go to
C:\xampplite\phpMyAdmin\config.inc.php
On line 22 enter the password you set.
Change:
$cfg['Servers'][$i]['password'] = '';
to:
$cfg['Servers'][$i]['password'] = 'WhateverPasswordYouSet';
Now you're back in!
Best go back and reset the root user to no password and then reset it to such in config.inc.php