Page 1 of 1

mysql errors

Posted: Fri Jul 15, 2005 11:24 am
by smiley
hi frns,
I've been using this serendipity with my mysql database since long.........Till yesterday, its working fine. But yesterday, i tried to install a s/w called trackplus in my database and i gave privileges to it........suddenly my serendipity stopped working. all the other applications in php with mysql are working fine but don't know what happened to serendipity!!! The following are my errors:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\espresso\include\db\mysql.inc.php on line 149

Warning: mysql_select_db(): Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Program Files\Apache Group\Apache2\htdocs\espresso\include\db\mysql.inc.php on line 150

Warning: mysql_select_db(): A link to the server could not be established in C:\Program Files\Apache Group\Apache2\htdocs\espresso\include\db\mysql.inc.php on line 150
DATABASE_ERROR

Anybody, plzz help me.......I'm direly in need of serendipity!!! :oops:

Re: mysql errors

Posted: Fri Jul 15, 2005 12:29 pm
by garvinhicking
The problem you are getting meens that your MySQL Server has been upgraded but your PHP does not support the new method.

That other PHP applications seem unaffacted may happen because they are using the MySQLi interface.

Please talk to your Server Administrator to upgrade PHP with the matching client library for MySQL.

You can google for that error message, it is not specific to Serendipity; so either the software you talk about has upgraded your MySQL, or somebody else upgraded your MySQL...

If MySQLi extension is available in your PHP install you can try to edit your serendipity_config_local.inc.php file and replace "mysql" with "mysqli".

Regards,
Garvin