PHPMyAdmin install issue

[jarvis]

Hi all,

 

I'm trying to install PHPMyAdmin but get the annoying error:

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

I'm running a PC with win xp pro

Apache 2.0.63

PHP 5.2.10

MySQL 5.1.38

PHPMyAdmin 3.2.1

 

Apache, PHP and MySQL run fine on there own. It's simply PHPMyAdmin not playing ball.

 

My config file  shows

[php
<?php
$i = 1;
#$cfg['http://localhost/phpMyAdmin'] = 'http://localhost/phpMyAdmin/';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['password'] = 'password';
?>
[/code]

I've not copied any lib.dll files into the C:|windows or sysem32 dir. I've also got the libmysql.dll and libmysqli.dll files in my php dir.

Is there anything I can check or do?

 

many thanks

 

[trq]

You can check if the mysqli extension is loaded via phpinfo.

[jarvis]

Hi thorpe, I've just checked and mysql only shows here:

_ENV["Path"]:

C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\php5;C:\Program Files\MySQL\MySQL Server 5.1\bin

PATH 

C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\php5;C:\Program Files\MySQL\MySQL Server 5.1\bin 

There is no seperate header which I thought there should be!?

 

My php.ini file has the following

extension_dir = "C:\php5\ext\"

I also have the following extensions

;extension=php_bz2.dll

;extension=php_curl.dll

;extension=php_dba.dll

;extension=php_dbase.dll

;extension=php_exif.dll

;extension=php_fdf.dll

extension=php_gd2.dll

;extension=php_gettext.dll

;extension=php_gmp.dll

;extension=php_ifx.dll

;extension=php_imap.dll

;extension=php_interbase.dll

;extension=php_ldap.dll

extension=php_mbstring.dll

;extension=php_mcrypt.dll

;extension=php_mhash.dll

;extension=php_mime_magic.dll

;extension=php_ming.dll

;extension=php_msql.dll

;extension=php_mssql.dll

extension=php_mysql.dll

extension=php_mysqli.dll

;extension=php_oci8.dll

;extension=php_openssl.dll

;extension=php_pdo.dll

;extension=php_pdo_firebird.dll

;extension=php_pdo_mssql.dll

;extension=php_pdo_mysql.dll

;extension=php_pdo_oci.dll

;extension=php_pdo_oci8.dll

;extension=php_pdo_odbc.dll

;extension=php_pdo_pgsql.dll

extension=php_pdo_sqlite.dll

;extension=php_pgsql.dll

;extension=php_pspell.dll

;extension=php_shmop.dll

;extension=php_snmp.dll

;extension=php_soap.dll

;extension=php_sockets.dll

;extension=php_sqlite.dll

;extension=php_sybase_ct.dll

;extension=php_tidy.dll

;extension=php_xmlrpc.dll

extension=php_xsl.dll

;extension=php_zip.dll

Is there anything else I can check?

 

Thanks

[Zane]

 

 

You can do all that but you can't check your phpinfo file?

[jarvis]

@zanus, I can check the phpinfo file but it's not showing anything about MySQL and I believe it should. This would more than likely explain why PHPMyAdmin is not working!

[trq]

If a call to phpinfo shows nothing relating to mysql* are you sure your editing the correct php.ini file?

[jarvis]

Yep, the ini file is in my C:/php5 dir

[jarvis]

I wonder if the version of php I have is not compiled with mysql?

 

Under the configure command, it's not listed:

cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared"

[trq]

The extensions are compiled stand alone as far as I know (im not a windows user though).

[jarvis]

I don't really want to go down the WAMP route if I can help it but fast losing hair at this rate!