Page 1 of 1

MySQL Deactivated ???

PostPosted: 12. August 2009 11:50
by whitetimer
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

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 12:07
by Wiedmann
- 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?

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 12:20
by DennisJN
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.

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 12:32
by Wiedmann
I have the same problem

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

Starting from the mysqld.exe --console from the command line

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).

090812 21:01:33 [ERROR] listen() on TCP/IP failed with error 10013

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

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 12:40
by whitetimer
Code: Select all
- 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?


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

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 13:09
by Wiedmann
i went to the security page to set the root password for phpmyadmin

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:
Code: Select all
<?php
    if (@mysql_connect("localhost", "pma", "")) {
        echo "OK";
    } else {
        $err = mysql_errno();
        if ((1044 == $err) || (1045 == $err) || (1130 == $err)) {
            echo "OK";
        } else {
            echo "NOK";
        }
    }
?>

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 13:18
by whitetimer
Thanks, its now sorted ... Just loving xampp ... :D

Re: MySQL Deactivated ???

PostPosted: 12. August 2009 14:41
by skuipers
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

Re: MySQL Deactivated ???

PostPosted: 12. September 2009 22:30
by foxy001
This solution worked for me to. Cheers.

What does that code change in the php exactly?

Re: MySQL Deactivated ???

PostPosted: 22. October 2009 04:36
by gamulz
Thanks for the solution, very helpfull... :D

Re: MySQL Deactivated ???

PostPosted: 26. October 2009 03:18
by CiD
foxy001 wrote:This solution worked for me to. Cheers.

What does that code change in the php exactly?

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 :roll:

Re: MySQL Deactivated ???

PostPosted: 26. October 2009 04:15
by Wiedmann
bad coding...not professionel...

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

Re: MySQL Deactivated ???

PostPosted: 07. January 2011 18:20
by jsusbna
great work, tnx.