Welcome Guest, Not a member yet? Register   Sign In
strange database problems
#1

[eluser]richzilla[/eluser]
Hi all, im having a bit of a strange problem with database connection and im trying to rule out a problem with my code before i go after tech support with it (im reluctant... theyre rubbish) Basically under CI any connection to mysql databases results in a database error:
Code:
A Database Error Occurred
Unable to connect to your database server using the provided settings.

I know the settings are definitely correct, there the same ones used for all my other projects and ive double checked them several times. I tried a normal php script to see if it was any more verbose in its response and got:


Code:
Warning: mysql_connect() [function.mysql-connect]: OK packet 6 bytes shorter than expected in H:\Program Files\wamp\www\dbtest.php on line 7

Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using old authentication in H:\Program Files\wamp\www\dbtest.php on line 7

is there anything i can do about this from my end, or is it definitely a tech support job?

cheers
#2

[eluser]rogierb[/eluser]
You are using a 16 characters long pwd hash to connect to the database while the 4.1+ has a larger hash.
Basically you need to reset/change the password to connect.

http://dev.mysql.com/doc/refman/5.1/en/old-client.html




Theme © iAndrew 2016 - Forum software by © MyBB