phpmyadmin is denying me access when I try and use it through http://localhost/xampp homepage

Question

I am using a mac laptop running mac os x version 10.5.8 and I need to export a database to an .sql file so I can push it to github for a project. However when I attempt to use phpmyadmin for this through the localhost homepage, when I click on the link it responds with a page with just this error message:

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO)

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.

But it doesn't even prompt you for user information to begin with? is there something I am missing? someone please help

Answer 1

The problem is in your phpmyadmin configuration on the server.

You can see the documentation here: http://www.phpmyadmin.net/documentation/#setup_script

The setting you are looking for is "$cfg['Servers'][$i]['auth_type']" - set this to 'HTTP', and you will be able to input a username and password.