Can't connect to mysql 'MySQL 4.1+ using old authentication in...'

[andygrant]

Hi

I haven't run PHP locally before on my PC and have tried doing so with AppServ 2.6. I seems to be fine doing test pages but when trying any websites that connect to a mysql database I'm getting the errors below and haven't been able to fix them. I would apprieciate if anyone knows what I need to change.

Errors:

Code:Warning: mysql_connect() [function.mysql-connect]: OK packet 6 bytes shorter than expected. PID=5880 in C:\AppServ\www\... on line 17

Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\AppServ\www\... on line 17

Warning: mysql_connect() [function.mysql-connect]: in C:\AppServ\www\... on line 17
We appear to be having some database connection issues, please try again later.

Code line 17:

mysql_connect($hostname, $username, $password);

Is mysql_connect out of date now, I tried mysqli_connect but that didn't help either.

Cheers

[imaginethis]

Try changing the password on the database.

"mysqlnd cannot connect to MySQL 4.1+ using old authentication" tells
you what the error is, please don't use the --old-passwords MySQL
option!