CODEWITHSUNDEEP
phpmyadminxampp
Mad Yo
Mad Yo

Reputation: 39

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

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) 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
 */
?>

Upvotes: 3

Views: 34061

Answers (5)

masafood
masafood

Reputation: 375

this is what i did to fix the same error. I initally had something runing on port 3306 which is what sql server uses when xampp is first installed. so i fix the port to 3307. which then fixed the port issue but not authentication. So i went into the config file of phpmyadmin and changed my user to

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

when i first installed mysql server, i had my user and password set to be the following above. so when xampp tries to access my sqlserver, it will want the same authentication or will not use it.

so pma user does not exsit unless you have created it.

Upvotes: 0

vladatr
vladatr

Reputation: 626

This can happen after changing mysql port. In that case, just click the upper left icon Empty session data.

Upvotes: 3

aarju patel
aarju patel

Reputation: 1

This problem or error happen When I installed XAMPP in two different drive, After removing XAMPP in another drive and have only one XAMPP folder in my system , this error fixed for me

Upvotes: 0

Amin Adel
Amin Adel

Reputation: 1028

this error sometimes happen for me too. this time I tried another browser and it was working fine! ... so I cleared site data and it fixed. so before doing any other solutions try to clear site data first. hope it fix.

Upvotes: 1

James Wong
James Wong

Reputation: 4619

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

Upvotes: 9

Related Questions