Krillins MySQL Error

[drunk3nrabbit]

When I try to use Krillins front end i get this error

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

Here is my Server's site

To view the content, you need to sign in or register

If I use a simple account creation page, it works fine.

I'm using MySQL 5.1 and I've set the server to allow remote connections.

I'm hosting the frontend on a remote host, the SQL database on one comp and ASCENT rev 3255 on another.

ascent connects and works just fine, just krillins is not working.

 

[Paco44]

Try to use MySQL 5.0.

 

[drunk3nrabbit]

I downgraded to 5.0 and i still get the same issue

 

[drunk3nrabbit]

i found that it has to do with the fact that php4 which i guess krillins is coded in dosen't support the password hashing in mysql 4.1 and above. i found this tutorial on the mysql site, but when i do the commands, nothing works. could someone maybe go over why they aren't working.

I'm really trying to get this done on my own, but its really difficult.

thanks
-ben