XAMPP on windows 7 not working properly

Question

Hey there,

I just installed XAMPP lite on Windows 7. I have two drives - C: for the OS and regular files, and an external drive E:. I installed XAMPP lite on E: (on the root), and its been giving me problems. Apache works well enough, but MySQL doesn't work. When I go to http://localhost/phpmyadmin/, it gives me the following error:

Error

MySQL said: 
#2003 - Can't connect to MySQL server on 'localhost' (10061)
Connection for controluser as defined in your configuration failed.

Any ideas as to what could be the problem? I used the zip file for XAMPP lite, the 32 bit version. This is on Windows 7 Home premium.

Thanks!

Answer 1

I have the same problem, are there any solution available.

Answer 2

You need to actually start the MySQL database server.

Start the XAMPP Control Panel and click the "Start" button just to the right of where it says MySQL. (Or run the "mysql_start" batch file)

Answer 3

i got the same problem... mysql is not working in windows 7... but i've tried it in vista it runs great with no problem... its seem very heavy in windows 7.....

Answer 4

Please edit your config.inc.php file in phpmyadmin subfolder inside xampp's installation, and specify '127.0.0.1' (instead of any other value like 'localhost) for the $cfg['Servers'][$i]['host'] setting as follows:

$cfg['Servers'][$i]['host'] = '127.0.0.1'; 

Then try with:

http://127.0.0.1/phpmyadmin

and it should work (at least it worked for me and I had exactly the same problem).

If this doesn't work you can try solutions described here:

http://forums.mysql.com/read.php?35,64808,254785#msg-254785

OR:

you can leava the setting mentioned above as:

$cfg['Servers'][$i]['host'] = 'localhost'; 

and edit %windir%\system32\drivers\etc\hosts adding the line (if it doesn't already exist):

127.0.0.1       localhost

Please note: I am using xampp beta which you can find here: http://www.apachefriends.org/en/xampp-beta.html

EDIT: Recently I have found this link http://www.ihostnz.com/howto-install-xampp-windows-7-xdebug-netbeans, followed the instructions there and now everything works like a breeze.