MySQL database DEACTIVATED

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

MySQL database DEACTIVATED

Postby Sxecurity » 20. September 2010 04:59

New xampp installation, change root pass, mysql pass & pma pass & w00t

------> MySQL database DEACTIVATED
so why?
Really i dont have the answer for u but we have this code

go to \xampp\htdocs\xampp\mysql.php

Code: Select all
<?php
   if (@mysql_connect("localhost", "pma", "")) {
      echo "OK";
   } else {
      echo "NOK";
   }
?>


replace with this

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";
        }
    }
?>


& now u have
MySQL database ACTIVATED
.....
3 days looking for the fix lolz, now you'll have better luck.

DEACTIVATED, ACTIVATED, root, MySQL database, pma, xampp, hamburger

**************************************************
existe la voluntad, existen los recursos
no existe la voluntad, existen las excusas
desde que se inventaron las excusas
the world is perfect...
**************************************************
Sxecurity
 
Posts: 1
Joined: 15. September 2010 19:16

Re: MySQL database DEACTIVATED

Postby Altrea » 20. September 2010 05:11

Sxecurity wrote:Really i dont have the answer for u

Well, thats quite easy.
The Script only tries to connect to pma with default login data.
If you change your password, the connect fails.

Thats the reason why the status scripts says mysql is deactivated, but it isn't.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL database DEACTIVATED

Postby Jim.Crutchfield » 29. September 2010 04:28

Hello. I'm very new at this, so please forgive my confusion. My status page says MySQL is deactivated. I revised mysql.php as recommended by Sxecurity, then restarted Lampp, but the status page still says MySQL is deactivated. If I understand Altrea's post, the status page is telling me a lie because I changed my password--it says MySQL is deactivated but it's really activated.

Because I haven't managed to load any database files into my database yet (can't connect with FileZilla: see viewtopic.php?f=17&t=42075), I don't know how to check whether or not MySQL is really active or not. Can anybody tell me how to do that? And if it is active, isn't there some way to make the status page tell me that?

Thanks for any help.

Regards,

Jim Crutchfield
Jim.Crutchfield
 
Posts: 3
Joined: 28. September 2010 00:53

Re: MySQL database DEACTIVATED

Postby Altrea » 29. September 2010 04:34

Jim.Crutchfield wrote:I don't know how to check whether or not MySQL is really active or not. Can anybody tell me how to do that?


You can either check the running status of mysql in the XAMPP control panel (if there is a green running label for mysql, your mysql-server is running) or you can try to login with your new password in phpmyadmin (if you can login, mysql is running. If not, it depends on the error message you get there).
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL database DEACTIVATED

Postby JonB » 02. October 2010 13:43

Jim :

I have two questions:

A - how exactly did you plan to get your datbase files imported?

B - where exactly is this physical server located? (do you have physical access to it?)

:?:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: MySQL database DEACTIVATED

Postby wrecker69 » 10. January 2011 18:56

Hello all,

I am having a similar issue with my MySQL. I am running XAMPP (full version) on Windows 7 Home Premium (64 bit). Up until very recently every aspect of XAMPP worked perfectly. I have implemented security and new user names and passwords and it was all working just fine. 2 days ago the MySQL stopped starting. I would try to start it from the control panel and nothing. No error report or anything. When I try to open and login to phpmyadmin I get this error code,

#2003 - Can't connect to MySQL server on 'localhost' (10061)

Connection for controluser as defined in your configuration failed.

Any ideas? I did try to add a port exception in my Anti virus program but not sure if I included the correct msql file. The file I made an exception for was msqld.exe and port 3306.

Any help with this would be greatly appreciated.

wrecker69
wrecker69
 
Posts: 26
Joined: 09. April 2007 16:09


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 115 guests