Apache Friends Support Forum

Hi, First time I installed XAMMP on my pc i got an error message when trying to connect to my phpadmin this is what i got

Access Denied "
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
mysqli::real_connect(): (HY000/1045): Access denied for user ''@'localhost' (using password: YES)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."

I have tried researching but cant find anyting

this is the code in the config.inc

"<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* 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'] = 'config';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

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

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

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

?>
"

Hi,

Are you sure the MariaDB version of XAMPP is running and not a different one?

Hi I would think so I’ve downloaded the Most recent version of XAMPP, I am new to XAMMP but I’ve had a look into the the file location and can’t seem to find “MARIADB”?

There are only two reasons why this issue can happen:
Either there is another MySQL Server running on port 3306 and not the XAMPP MariaDB one
or you have manipulated the default users or configuration files coming with XAMPP.

What is the full contents of the XAMPP control panel log?

so i just uninstalled xampp and deleted all files, re-installed and its working now but this is what the log was saying before i uninstalled it

[main] Initializing Control Panel
[main] Windows Version: Home 64-bit
[main] XAMPP Version: 7.4.11
[main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
[main] You are not running with administrator rights! This will work for
[main] most application stuff but whenever you do something with services
[main] there will be a security dialogue or things will break! So think
[main] about running this application with administrator rights!
[main] XAMPP Installation Directory: "c:\xampp\"
[main] Checking for prerequisites
[main] All prerequisites found
[main] Initializing Modules
[main] Starting Check-Timer
[main] Control Panel Ready
[Apache] Attempting to start Apache app...
[Apache] Status change detected: running
[mysql] Attempting to start MySQL app...
[mysql] Status change detected: running


the log seemed to be okay without any errors I am not sure why this happened but re installing the software seemed to work for me Thanks anyway my friend.

Great you got this solved