Apache Friends Support Forum

Hi There

I have just installed the latest release of xampp (loving it by the way) onto a clean Windows install and when i bring up the xampp status page it says that MySQL is Deactivated ? Any suggestions ?

Many Thanks

- Have you changed anything after the installation (passwords, config files, etc.)?
- Apache, MySQL is running as Application or Service (Svc checked in CP)
- You installation path?
- Your operating system?
- This happens every time you access the status page?
- Any errors/warning during execution of the setup script?

I have the same problem

Starting from the mysqld.exe --console from the command line gives the following results

C:\xampp\mysql\bin>mysqld --console
090812 21:01:32 [Note] Plugin 'FEDERATED' is disabled.
090812 21:01:32 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
090812 21:01:32 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.p
rimebase.org
090812 21:01:33 InnoDB: Started; log sequence number 0 46409
Can't start server: listen() on TCP/IP port: No such file or directory
090812 21:01:33 [ERROR] listen() on TCP/IP failed with error 10013
090812 21:01:33 [ERROR] Aborting

090812 21:01:33 InnoDB: Starting shutdown...
090812 21:01:34 InnoDB: Shutdown completed; log sequence number 0 46409
090812 21:01:34 [Note] PrimeBase XT Engine shutdown...
090812 21:01:34 [Warning] Forcing shutdown of 1 plugins
090812 21:01:34 [Note] mysqld: Shutdown complete

I would imagine that TCP/IP would be active as I have no problem with internat access.

Before upgrading to this latest version I needed to start mysqld.exe directly. It wouldn'd start from the control panel or the batch file.

Regards

Dennis.

Which problem:
- You can't start MySQL?
- You can start MySQL, but it's shown as "deactivated" in the status page?


I guess that's not the default way in XAMPP to start MySQL. Please use:
- the "mysql_start.bat".
- ot the XAMPP Control Panel
- or the xampp cli (xampp_cli.exe start mysql).

If it can't start, there should be something in the MySQL *.err file (\xampp\mysql\data).


Maybe your networkcard is not active or a firewall is blocking "mysqld.exe".

Hi Wiedman

After install, i went to the security page to set the root password for phpmyadmin and apart from that i have not changed anything. I have Apache, MySQL, Tomcat set as Service which are all running (if i look at the Services through Windows Administration). My install path was C:\ and i use Windows 7 RTM. Apache runs smooth, so does Tomcat and i can access MySQL through phpmyadmin just fine. But when i look at the Status page it reports MySQL as Deactivated

Did not encounter any errors during setup either.

Many Thanks

Ah, thanks. A small bug:
The "root" user password is not the problem. But you have also checked to set a password for the phpMyAdmin User 'pma'.

To fix this, you can can replace the file "\xampp\htdocs\xampp\mysql.php" with:

Thanks, its now sorted ... Just loving xampp ...

This does the trick for me as well. Wonderful fast support again!

I guess this temporary fix will become permanent in the next XAMPP release?

Thanks again.
Simon

This solution worked for me to. Cheers.

What does that code change in the php exactly?

Thanks for the solution, very helpfull...

It checks for some error-massages and set Errors to noErrors like "Access Granted" whether with or without error... bad coding...not professionel... like a newbie says "I dont like erorrs, i dont wanna see them, take em off !"

But it works

Fine. This code is looking for a "working" MySQL server. How would you code this?