Support
Database
Database connections from ASP fail with 'Client
does not support authentication
protocol requested by server'.
Sun
ONE ASP does not support the default authentication
method used by MySQL 5. Instead it is necessary
to make MySQL use the 'old-style' authentication.
To do that, first log in to MySQL via SSH and
then use the 'old_password' function to change
the authentication style:
$
mysql -p -u username databasename
Password: [enter password]
mysql> set password = old_password('password');
mysql> quit
Bye
$
