problem with phpmyadmin

nickk

I recently installed MySQL, so the database is not outdated, but while trying to use phpmyadmin, I get the following error "#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client " my username/password, etc are all configured properly. Any suggestions?

devinemke

read this

nickk

Ok, thanks, he sais the following: "the other alternative is to use the new mySQLi functions, which use the newer cleint library (libmysqli.dll)." , how exactly would I go about doing that?

devinemke

assuming you are using the lastest version of phpmyadmin and have the mySQLi extension enabled in PHP, there is a setting in config.inc.php where you can set which extension to use. read the phpmyadmin documentation.

nickk

no, it is not enabled in php.ini, how would I go about doing this? The documentation tells me this : " To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP server (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or 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.". This doesnt help me much. Sorry, but what should I do to solve this? All of my php scripts stopped working with this error 🙁

devinemke

you should read the manual section on Installation and Configuration. there is a whole section on installation of extensions.

nickk

I downloaded the PECL pack, and there is no mysql.dll or mysqli.dll of php_mysql.dll or anything along those lines, I'm sorry for the basic questions but I am lost 😕

tsinka

Hi,

these dlls are part of the zip package you can download at www.php.net (PHP 5.x).

Which PHP version do you use ?

EDIT: that's wrong ... libmysqli.dll should additionally come with MySQL 4.1.x.

Thomas

nickk

I have PHP4, does that mean that I have to upgrade to PHP5 to use this? 🙁

tsinka

I think PHp 4.x doesn't support the mysqli functions.

The manual says: PHP >=5.0

But I might be wrong.

Thomas

nickk

Huh, well thats a bitch, to use phpmyadmin I have to install php5 (which I think is still not very widely in use).

devinemke

Originally posted by nickk
...to use phpmyadmin I have to install php5...

no, phpmyadmin works perfectly well in PHP4, you just have to use the regular mySQL extension. you should re-read this, there is an explanation of how to configure old passwords with mySQL 4.1.

nickk

Ok, I decided to install PHP5 because I will need to soon anyway. I followed this tutorial: http://www.tutorialized.com/tutorial/Installing-a-Webserver-on-Windows-VERSION-2/5604
and now phpmyadmin works fine, but for sme reason when I start apache, it doesnt want to load the module php_mysql.dll (and it loads php_mysqli.dll fine). The dll's are all in the right directory, and the appropriate fileds are uncommented in php.ini, apache gives me this error:
"PHP Startup: Unable to load dynamic library 'C:\php5\ext\php_mysql.dll' - The specified procedure could not be found."
If I comment the field "extension=php_mysql.dll", phpmyadmin works fine, but every other script that uses standard mysql doesnt work. Why doesnt this module want to load?

tsinka

Did you copy the libmysql.dll that comes with php5 to the system32 directory ?

EDIT: If you copied the dlls to the apache directory like shown in the tutorial => make sure that there are no PHP4 dlls in system32.

Thomas

nickk

thanks, copying libmysql.dll helped 😃