mysql_connect () error

Mike-2003

I'm in the process of trying to connect to a database with the following:

$db_conn = mysql_connect("localhost", "root", "97svt") or die("unable to connect to the database");
mysql_select_db("techdb", $db_conn) or die("unable to select the database");

And I get an error like this one:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Apache\Apache2\htdocs\Forum\config.php on line 14
unable to connect to the database

I wanted to see if I have done something wrong. I'm using Apache 2.0 and MySQL 4.1.

Any help will be greatly appreciated!

Thanks,
Mike

drew010

mysql_* function in php dont work on mysql versions greater than 4.1.0. so check again the version and see if its above 4.1. if so you have to use [man]mysqli[/man]

Mike-2003

I did check it and it is 4.1.13.

Will I need to download the extensions or just follow the instructions located at the link you gave me?

Thanks,
Mike

drew010

yeah php has to be configured to use it. are you on windows or linux?

Mike-2003

I'm Windows

drew010

you should have php 5 for this and in the ext folder you should see a php_mysqli.dll. open your php.ini file. make sure the extension_dir directive is pointing to the folder where the dlls are, uncommend extension php_mysqli.dll by removing the ; from in front of it. restart the webserver and you should be able to use mysqli now.

Mike-2003

I checked my PHP version and it is 4.4.0.

Should I upgrade to 5.0 or can I make the mysqli work on PHP 4.4.0?

Thanks,
Mike

drew010

the dll isnt shipped with version 4, but you can download the v5 zip package and first try copying the php_mysqli.dll file to the php4 ext directory and add the extension php_mysqli.dll to your php4 php.ini and see if it works. if errors come up either while starting the webserver or calling a php page you will have to try 5. ive never used mysqli on version 4 so i dont know if it works that way. let me know if it does work out.

Mike-2003

I'll try it.

Thanks for all your help!

Thanks,
Mike

Mike-2003

Drew010,

I tried it and it came up with errors :queasy:

Oh well, I guess I 'll install PHP 5.0.

Thanks again for all your help!

Mike

drew010

ok good to know. i guess php 5 it is.