WampServer

Latest WAMP installed fine, no problems, BUT...

When going to phpMyAdmin, I get the error from phpMyAdmin as follows:

"Cannot load mysqli extension. Please check your PHP configuration".


Also, phpMyAdmin documentation explains this error message as follows:

"To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.
Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar."


Finally, the apache_error.log file has the following PHP warnings (see the mySQL warning):

PHP Warning: Zend Optimizer does not support this version of PHP - please upgrade to the latest version of Zend Optimizer in Unknown on line 0
PHP Warning: Zend Platform does not support this version of PHP - please upgrade to the latest version of Zend Platform in Unknown on line 0
PHP Warning: Zend Debug Server does not support this version of PHP - please upgrade to the latest version of Zend Debug Server in Unknown on line 0
PHP Warning: gd wrapper does not support this version of PHP - please upgrade to the latest version of gd wrapper in Unknown on line 0
PHP Warning: java wrapper does not support this version of PHP - please upgrade to the latest version of java wrapper in Unknown on line 0
PHP Warning: mysql wrapper does not support this version of PHP - please upgrade to the latest version of mysql wrapper in Unknown on line 0



So, for some reason PHP is not recognizing the mysql extension.

Anyone know why? Any solution or workaround?

Thanks.

I have some of my own code which connects to mySQL and is working on a live server.

On WAMP 2.0, I get an error msg that mysql_connect() is an undefined function.

It seems, some PHP library(ies) necessary for PHP to talk to mySQL are either missing or are not working in wamp 2.0.

Has anyone else experienced this?

You forget to enable php_mysqli extension. To enable it: click on PHP menu in Wamp tray icon. Then go to Extension submenu and scroll down the list to find php_mysqli. Click on it to enable it. Then you should see the WAMP Tray Icon turns yellow then it will turn white again (it means Wamp restart is success)

php_mysqli is enabled, but still cannot load the mysqli extension.

I've just about given up... fairly convinced (for my XP configuration at least) that wamp 2.0 does not work out of the box.

For some reason (unfortunately I don't know enough about configuring PHP) PHP is not able to find the mySQL libraries.

I've reinstalled wamp 2.0 twice, done what I know to check the relevant path settings in php.ini and httpd.conf. Tried manually replacing mysql, php with three different versions.

Still no luck - think I will try installing apache, php and mySQL manually.

Found the problem. It was my configuration.

I had to first uninstall Zend Optimizer, Zend Platform, Zend Studio, and any other Zend extensions I had.
Then I Uninstalled wampserver.
Then I Restarted the PC.

Basically I cleaned house.

After it came back from the restart, I reinstalled wamp 2.0.

Problem gone - I can get into phpMyAdmin no problem.

Quote

I had to first uninstall Zend Optimizer, Zend Platform, Zend Studio, and any other Zend extensions I had.

You just remind me that this wamp version doesn't have Zend Optimize add-on yet :-(

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

After 3 days trying to solve this problem, I found the answer that works for me.

I replaced php_mysql.dll and php_mysqli.dll with the ones that come with the php install when you specify to add mysql and mysqli extensions. Restarted WAMP and it works.

I have installed wamp and was able to access phpmyadmin fine until recently, it seemed to stop working.
I haven't edited any files or anything. I tried re-installing and that didn't work for me either.. any ideas?

A suggestion, do not install WAMP in a location that has spaces in the path (ex. "c:\Program Files\wamp" ). I've had the mysqli issue and other issues in Windows XP and Windows Vista when I installed into the Program Files directory.

When I reinstall into a path without spaces (ex. c:\ProgramFiles\wamp" ), the mysqli issue (and some other issues) go away.

Thanks. I got it working. After installation, restart the computer, that's all.

If that doesn't work, try the other suggestions in the thread, but restarting fixed that problem with me.

In Vista, I'm sure that you installed wamp in (x86) folder and parentheses were the problem.
You can install it directly in C: folder if you want.
Else you could add quotes around the path to solve the problem...

But if it works, it's okay

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Really getting tired of this one
Kan de mysqli-extensie niet laden. Controleer de PHP configuratie
(Cannot load mysqli-extension, Check PHP configuration)

Extension shows ok in screen en file

;extension=php_mssql.dll
;extension=php_mysql.dll
extension=php_mysqli.dll

Tried all above....

On Vista with MySQL 5.1.3 server. Teh MySQL server is perfectly reachable via WAMP

HELP!

Really getting tired of this one

Cannot load mysqli-extension, Check PHP configuration


Tried all above still not getting it....

I also tried checking the php extension and marked mysql and mysqli but then it show 403 error which means that it is connecting to that site but not have permission to access that page

hi i got it......the solution is here...


Probably you are trying to access your phpmyadmin. You will get this error if you have more then one

“php.ini” file in your system. It is kinda conflicting. For instance i have wampserver2.0 and IIS7 together in my

current system. I have activated IIS7 FastCgı method to use php on it. So it has one php.ini file at path of

“c:\wamp\….” and another one in “c:\Program Files\Php” . You can get a temporary solution if you rename

your php.ini file which is in your “program files” path.


Just try it ....all the best....

you can try something like that: [mrer.org.ua];

Hi,

I hav installd wamp on my vista-32 .Localhost is wrkin fine but myphpdomain is not wrkin and it gives the followin error
Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I have installed wamp twice it is givin the same error..Can ani one help ...wats d pb???

download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

I had exactly the same problem. Tried lots of proposed solutions and finally found the solution that solved the problem for me:
I had an old installation of a standalone php version that I removed, but the uninstall did not remove the php.ini file. It was this php.ini that was causing the problem, apparently the wamp php was using this php.ini file. I removed the old php.ini file and phpMyAdmin works fine now.

asha Wrote:
-------------------------------------------------------
> hi i got it......the solution is here...
>
>
> Probably you are trying to access your phpmyadmin.
> You will get this error if you have more then one
>
>
> “php.ini” file in your system. It is kinda
> conflicting. For instance i have wampserver2.0 and
> IIS7 together in my
>
> current system. I have activated IIS7 FastCgı
> method to use php on it. So it has one php.ini
> file at path of
>
> “c:\wamp\….” and another one in
> “c:\Program Files\Php” . You can get a
> temporary solution if you rename
>
> your php.ini file which is in your “program
> files” path.
>
>

Eddy Wrote:
-------------------------------------------------------
> I had exactly the same problem. Tried lots of
> proposed solutions and finally found the solution
> that solved the problem for me:
> I had an old installation of a standalone php
> version that I removed, but the uninstall did not
> remove the php.ini file. It was this php.ini that
> was causing the problem, apparently the wamp php
> was using this php.ini file. I removed the old
> php.ini file and phpMyAdmin works fine now.

> Just try it ....all the best....

This also was my problem.