If you ever get this error when trying to connect your application to a MySQL server, it’s because as of 4.1 MySQL made changes to the authentication method used. Most hosts are still running PHP that does not support this new authentication and so any application (PHPBB, etc) that you try to install won’t work.

A workaround for this is that you can configure MySQL to use the old password format for a specific account. You do that with the following SQL command:

[code:1:cb08e73675]
SET PASSWORD FOR ’some_user’@’some_host’ = OLD_PASSWORD(’newpwd’);
[/code:1:cb08e73675]

(Obviously use your own username/password.) This will instruct MySQL to use the older password format for the specified account. Once you do this, clients that don’t support the new password format will be able to login using this account.

More information can be found at [url]http://dev.mysql.com/doc/mysql/en/common-errors.html[/url]