[SOLVED] Mysql broken thingy

[firecat318]

When I try to load my connection.php file, I get this dumb error.

 

Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

And here is my connection.php file

 

<?php

mysql_connect("p41mysql77.secureserver.net", "t****ng", "mypass") or die(mysql_error());
echo "Connected to mysql!";

?>

 

I've been reading around, and I keep reading that this only happens in versions 5.0 and above.  So I downgraded to 4.1 and this still happens!  I really need this database to start working soon too.

 

NOTE:  Don't tell me to use localhost either, that host is specified from my host.

 

 

[PFMaBiSmAd]

You need to tell us specifically what it is that you are changing between version 4.1 and 5.0 and are you sure what you are changing is actually occurring.

 

Also what is the php version and the mysql Client API version that php is using on your system.

[firecat318]

I've downgraded from 5.0 because this same problem was happening.  I downgraded, and now its still happening.  This database isn't on my computer at home, but its hosted by Godaddy.  I've tried a lot of solutions to this problem, but none of them seem to help. 

[firecat318]

I've read some places that you have to update some old password thing, because mysql uses a new algorithm now.  I tried that code but it didn't work either.

[firecat318]

hmm i've got the piece of shit to work now.