MySQL Deactivated ???

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL Deactivated ???

Postby whitetimer » 12. August 2009 11:50

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
whitetimer
 
Posts: 3
Joined: 12. August 2009 11:45

Re: MySQL Deactivated ???

Postby Wiedmann » 12. August 2009 12:07

- 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?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL Deactivated ???

Postby DennisJN » 12. August 2009 12:20

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.
DennisJN
 
Posts: 2
Joined: 12. August 2009 12:13

Re: MySQL Deactivated ???

Postby Wiedmann » 12. August 2009 12:32

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".
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL Deactivated ???

Postby whitetimer » 12. August 2009 12:40

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
whitetimer
 
Posts: 3
Joined: 12. August 2009 11:45

Re: MySQL Deactivated ???

Postby Wiedmann » 12. August 2009 13:09

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";
        }
    }
?>
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL Deactivated ???

Postby whitetimer » 12. August 2009 13:18

Thanks, its now sorted ... Just loving xampp ... :D
whitetimer
 
Posts: 3
Joined: 12. August 2009 11:45

Re: MySQL Deactivated ???

Postby skuipers » 12. August 2009 14:41

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
skuipers
 
Posts: 99
Joined: 21. January 2005 16:27
Location: The Netherlands

Re: MySQL Deactivated ???

Postby foxy001 » 12. September 2009 22:30

This solution worked for me to. Cheers.

What does that code change in the php exactly?
foxy001
 
Posts: 1
Joined: 12. September 2009 19:50

Re: MySQL Deactivated ???

Postby gamulz » 22. October 2009 04:36

Thanks for the solution, very helpfull... :D
gamulz
 
Posts: 1
Joined: 22. October 2009 04:29

Re: MySQL Deactivated ???

Postby CiD » 26. October 2009 03:18

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:
CiD
 
Posts: 34
Joined: 30. January 2007 23:34

Re: MySQL Deactivated ???

Postby Wiedmann » 26. October 2009 04:15

bad coding...not professionel...

Fine. This code is looking for a "working" MySQL server. How would you code this?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL Deactivated ???

Postby jsusbna » 07. January 2011 18:20

great work, tnx.
jsusbna
 
Posts: 1
Joined: 07. January 2011 18:19


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests