xampp Access denied for user 'pma'@'localhost' (using password: NO)

Question

My phpmyadmin used to load but with the following errors. Haven't found a solution for it yet. Please let me know what I can do, thanks for your time and help.

Now it loads a blank page.

I pressed on the sql option and passed the following command - set password for root@localhost = password('something');

And then I configured phpmyadmin config.inc.php file by replacing 'config' in front of 'auth_type' by 'cookie' and adding my password in the empty '' under it. And that's when my phpmyadmin started going blank. I added my password in the empty '' in front of 'controlpass' under pma after that. Didn't help. I changed it back to the default settings and it'still not working.

xampp Access denied for user 'pma'@'localhost' (using password: NO)

<?php
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'xamppxamppxamppxamppxamppxamppxampp';
/* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;
/*
 * First server
 */
$i++;
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'bananashake';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$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]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

/*
 * End of servers configuration
 */
?>

Hello welcome to SO, can you post your phpMyAdmin config.inc.php — James Wong
I'm looking up on it but as you can see in the image, there is no privileges option in my main frame which is the first step of the solution suggested online. There is 'edit privileges' under User accounts and 'check privileges' under databases. Even then, the solution suggested online isn't seeming helpful. — Mad Yo
Yes James, however the config.inc.php is too long to post. Would you like me to remove the spaces and post it? Sorry I'm a noob here. — Mad Yo

James Wong James Wong · Accepted Answer · 2018-06-14T03:08:33

Based on the latest information you posted in the comments, it seems phpMyAdmin is connecting to your pre-existing MySQL install. To connect to your XAMPP MySQL DB, revert the changes to the config. (that is, auth_type = 'config')

And add this line to your phpMyAdmin config.inc.php

$cfg['Servers'][$i]['port'] = '3306'; //Change 3306 to the port number of your XAMPP MySQL

xampp Access denied for user 'pma'@'localhost' (using password: NO)

2 Answers