Tutorial :XAMPP on windows 7 not working properly



Question:

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!


Solution:1

This happened to me today, and it was because Dropbox.exe was using port 3306. If you run the Port-Check from XAMPP control panel, you will be able to see if there are any conflicting port issues.


Solution: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)


Solution:3

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.


Solution:4

Sometimes I get this error:

ERROR: MySql service not started [-1]  

when installing XAMPP on developers' machines (Windows-based), because often developers already have a MySql installation on their computers. MySql installs itself as service with the default name "MySql"; XAMPP uses this name too for his own MySql, it gets confused. So, my solution is:

  • remove existing "MySql" service, the one created by the MySql installer;
  • re-add it with a new name (not "MySql")
  • use XAMPP happily :)

Here is a more general article (in italian language, but you should figure it out): XAMPP: cosa fare quando qualche servizio non parte (Windows)


Solution:5

just go to the xampp folder then phpmyadmin folder. here u will see a user_password.php file. just make the password null


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »