Page 1 of 1

phpmyadmin not working

PostPosted: 02. March 2016 05:01
by jahodson3
I just installed XAMPP 5.6.15 for Windows on my Dell XPS 15 running Windows 10. Everything went great. I'm able to start Apache & MySQL (I'm guessing this is actually MariaDB behind the scenes) from the XAMPP Control Panel. I can request /localhost and the "XAMPP Apache + MariaDB + PHP + Perl" splash page comes up as expected. I did use the Control Panel Shell to set a password for the "root" database account.

However, when I request /localhost/phpmyadmin, I get an error "MySQL said: Cannot connect: invalid settings. 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 was expecting it to prompt me for a username/password, but I only get the error above, no prompt.

Any idea how to correct this?

Thanks,
Jim

Re: phpmyadmin not working

PostPosted: 02. March 2016 06:03
by jaspr04
go to xampp/phpmyadmin/config.inc.php and then chnage the $cfg['Servers'][$i]['auth_type'] = 'config'; to $cfg['Servers'][$i]['auth_type'] = 'http';. then you will be able to login by entering new password you recently set with user name of root

Re: phpmyadmin not working

PostPosted: 02. March 2016 21:22
by jahodson3
Perfect solution. Thanks.