Page 1 of 1

phpmysqladmin cant access mysql

PostPosted: 04. August 2012 05:29
by miltmobley
I just installed xampp 1.8.0 on W7 Home Premium SP1, all servers are running and your control app seems to work, but phpmyadmin can't access the mysql server
using user='root', password='no'. I can access the server with no problems using a recent mysqlworkbench instance using the same user and password info.
What could be causing this problem? I didn't see anything like this in the FAQ file.

Re: phpmysqladmin cant access mysql

PostPosted: 04. August 2012 11:29
by JonB
Hi Milt -

As Altrea likes to point out, a pleasant salutation is always polite - particularly when asking for help.

Now to your issue - what is the exact error you are receiving? (you don't say)

If its MySQL error 2002 -
The simplest solution might be to run the XAMPP 'security fix' - it sets the 'root' and 'pma' passwords and writes a .htaccess file for the xampp folder.
Its found on the XAMPP Security page.

The other solution is to manually set the 'pma' user PW and edit config.inc.php to reflect the login option you want.
http://wiki.phpmyadmin.net/pma/Quick_Install#Manually

Good Luck
8)