phpMyAdmin doesn't work, mySql is showing as deactivated.

[drop_lord]

I know next to nothing about software programming. I'm a bricks and mortar kind-of-guy.

Installed XAMPP.

I can access myaqladministrator.exe and access mysql.

mysql is running as a service.

MySql is showing as DEACTIVATED

and this is the error when clicking on phpMyAdmin

phpMyAdmin - Error

Cannot load mysqli extension. Please check your PHP configuration. - Documentation

I looked at the documentation but my eyes glaze over.

[JonB]

Couple questions first -

What Windows version?

What XAMPP version?

Then I guess I should explain that XAMPP has its own MySQL installation that is part of the package.

The fact that "MySQLAdministrator.exe" exists tell me that MySQL was installed standalone at some point (its not part of the XAMPP package). XAMMP is designed to use phpMyAdmin to roughly the same affect. (that's why the XAMMP MySQL doesn't want to run - there's already a MYSQL service running)

Did you install MySQL separately? (its OK if the answer is yes, we are just trying to get to the bottom of things)

I'll wait on giving a 'fix' for your answers.

Good Luck

[drop_lord]

XAMPP 1.7.3
XP Pro all the latest patches
XAMPP has it's own MySql.
MySql Administrator was installed separately.
There is no other copy of MySql on the computer.
The XAMPP MySql runs, it's the XAMPP MySQL and not some other one.

.... xampp\mysql\bin\mysqld.exe" --defaults-file="C:\SYSTEM\xampp\mysql\bin\my.ini" MySQL

Is the business end of the service loading command.

Tell me what to look for, oh helpful emissary.

[JonB]

MySql Administrator was installed separately.

What else was installed separately?

[drop_lord]

I dunno, iTunes.

What does that have to do with anything?

[JonB]

Well -

You likley broke XAMMP in some fashion when you "installed separate;ly" there.

Easy fix, un-install XAMPP, clean up - reinstall XAMPP (without installing any extra pieces) see if it works. If it does - don't "install extra things" anymore.

Good Luck



ysf

[drop_lord]

Apache2.x, then OpenFire, then MySql were installed.
The MySql Administrator, a stand-alone, separate program which 'talks' with MySql through the address:port, was installed.
Then Apache2.x and OpenFire and MySql were uninstalled.
Then XAMPP was installed, and along with that was the included MySql.
Now XAMPP knows *nothing* about MySql Administrator, a stand-alone app that interfaces with the MySql database when you run it. MySql Administrator has no file-system interaction with XAMPP. It could be as well installed on your local computer, and I could grant access from the computer here, and thereby you could interface with your MySql Administrator to the XAMPP MySql installation.

So now we have established the facts, what does the error mean in plain english so I can go fix it?

Thanks

[BigWetDog]

What is the installation path for xampp? Specifically, where is php_mysqli.dll? Also, do a search on you system and make sure there is only one php.ini.

[drop_lord]

yes. Thank you.

XAMPP installed to C:\SYSTEM\xampp\

php_mysqli.dll C:\SYSTEM\xampp\php\ext\
There are no other copies of php_mysqli.dll.

Only one php.ini on all of C:, and it's C:\SYSTEM\xampp\php\

I'll PM it to both of you.

Thanks again.

[BigWetDog]

Anything telling in your apache logs?

[drop_lord]

What am I supposed to look for?

[JonB]

Is C:\SYSTEM by any chance your acronym for the Windows systemroot?

just asking...

[drop_lord]

Ah, no. Did you think I learned how to install windows yesterday, then XAMPP the day after?


What am I supposed to look for in the apache logs?

[BigWetDog]

anything that might say somthing isn't loading and why.

[drop_lord]

I think the main apache has a log for that.

Been looking at errorlogs.
Have a couple of virtual hosts also though I presume the error you are mentioning is not in there.

I am working on it. Report back later.