Note To Self

In Note To Self by SEO AnseoLeave a Comment

Note To Others: Hello there! This article is part of the "Note To Self" series. While I hope it's of some help to you, it's primary function is to remind myself how I did something! As such it may go into less detail than other articles. If you're left with questions, feel free to give us a shout and we'll see if we can help!

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

2.
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

Leave a Comment