Running MySQL 4.1 with phpMyAdmin

[programmer]

when ever i try to run phpMyAdmin with MySQL 4.1 it gives the following error



cannot load mysql extension;
please check PHP configuration



and when i see it doc. phpMyAdmin FAQ's no. 1.20 says the following



I receive the error "cannot load MySQL extension, please check PHP Configuration".
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.



i can't understand what to do ? please help

phpMyAdmin works fine with MySQL 4.0 installation

[tflight]

If you run phpinfo() does it say that the mysql extension is loaded?

[programmer]

If you run phpinfo() does it say that the mysql extension is loaded?

the problem only comes with PHP 5.X.X versions not with PHP 4.1.X versions

there is no table for mySQL in PHP5's info page like PHP4 has. where to see mysql information?

[tflight]

well if there is no table for mysql in your phpinfo output then that would suggest that particular instance of php was compiled without mysql.

[programmer]

well if there is no table for mysql in your phpinfo output then that would suggest that particular instance of php was compiled without mysql.

then from where to get php5 compiled with mysql extention :confused:

[tflight]

If you are using php from your hosting company then you will have to ask them if they can provide php with mysql compiled. If you are running it on your own computer then you can download it yourself and either download a precompiled binary with mysql or compile it in yourself.

[programmer]

i am using it on my own computer and now i am going to php.net to see what's available for download. thanks for helping me.

[Geoff]

1. Place a copy of the file C:\PHP\libmysql.dll into your C:\Windows or C:\Windows\system32 directory preferably the latter. Mysql won't run properly and therefore many scripts like phpmyadmin won't work without doing this.

2. Open C:\Windows\php.ini and edit the line for your extension directory if necessary.
extension_dir = "C:\PHP\ext"

3. Open C:\Windows\php.ini and remove semicolon in front of the mysql extension so that it loads.
extension=php_mysql.dll

4. Open Apache httpd.conf file and add this somewhere in the file.
# configure the path to php.ini
PHPIniDir "C:\WINDOWS"

Those four things should get it working.

[ccrandall77]

I'm also having the exact same problem with my setup, however, I've tried all of the items suggested.

I'm running on a Win2K box with PHP 5.0.5 and MySQL 4.1.14. I'm able to run the page:

<?
phpinfo()
?>

and I'm able to connect to MySQL with a MySQL client. I just can't get PHP to load the MySQL dll.

I've loaded PHP under C:\php5 and MySQL is located in C:\Program Files\MySQL.

In my php.ini, I uncommented the line:

extension=php_mysql.dll

and I changed it to

extension=php_mysqli.dll

(either way, I still get the same problem). I also changed the extension_dir to both "./" and "C:\php5\ext".

In my system Path, I put C:\php5 AND C:\php5\ext.

When all of that didn't work, I tried using different slashes in my paths (\ instead of /), I put ALL of the dlls under C:\php5 and I tried putting libMySQL.dll in C:\Windows and C:\Windows\system and C:\Windows\system32... all of this stuff coming from a bunch of different pieces of documentation. I'm sadden to see how poor the standard PHP documentation is on this stuff.

I've been through this process on 3 different machines... starting fresh each time. Does anyone know what the deal is here?

I'm trying to do all of this to install TikiWiki, but it may just be easier to go back and try a Perl or Java Wiki as I've never had issues setting those up in the past.

Thanks
Curt

[brownhornet]

Has anyone ever solved this? As with the last post by Curt I feel as though I have tried everything. Well at least everything he has done.

Help! How can this be so poorly documented beyond the obvious everyone has mentioned.

Where should I start looking. 2008 and thinking of going back to PHP4