Database connections from ASP fail with ‘Client does not support authentication protocol requested by server’

This applies to Linux Hosting accounts only.

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 phpMyAdmin or another MySQL administration program and then use the ‘old_password’ function to change the authentication style by running the SQL query:

set password = old_password(‘password’);