Apache Friends Support Forum

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

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

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

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