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
$
Return
to category list
