Databases
StackOverflow2013
Postsdbo
POLocked out of PHPMyAdmin with XAMPP
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLocked out of PHPMyAdmin with XAMPP
    text
    copied!<p>I use CakePHP with Xampp on OSX and recently installed wordpress for the first time. I changed some passwords, which I didn't realize would affect PHPMyAdmin. Upon trying to go to localhost/phpmyadmin I'm prompted with a login screen. I wrote down the password and username that I changed, and still, it won't allow me in. I get the following error</p> <pre><code>Authentication required! This server could not verify that you are authorized to access the URL "/phpmyadmin". You either supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required. </code></pre> <p>I've tried doing <a href="https://stackoverflow.com/questions/10574568/changed-password-in-phpmyadmin-on-a-mac-using-xampp-now-unable-to-access-localh">what this post suggests</a> but it didn't work. </p> <p>This is the contents of my config.inc.php file</p> <pre><code>$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost'; //$cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysql if your server does not have mysqli */ $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = true; /* * phpMyAdmin configuration storage settings. */ /* User used to manipulate with storage */ // $cfg['Servers'][$i]['controlhost'] = ''; #$cfg['Servers'][$i]['controluser'] = 'pma'; # commented out by xampp security #$cfg['Servers'][$i]['controlpass'] = ''; #$cfg['Servers'][$i]['controlpass'] = ''; /* Storage database and tables */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; $cfg['Servers'][$i]['relation'] = 'pma__relation'; $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; $cfg['Servers'][$i]['history'] = 'pma__history'; $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords'; $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; $cfg['Servers'][$i]['recent'] = 'pma__recent'; /* Contrib / Swekey authentication */ // $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf'; </code></pre> <p>I even tried re-installing XAMPP. I've cleared my browser history between every change I made.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload