Edit the my.ini file

Newer versions of MySQL (4.1 and above) use a method of authentication which is incompatible with PHP versions below PHP 5. This is because the newer versions of MySQL changed the way passwords are stored, and older PHP versions do not use the same format.

If the versions you have installed are not fully compatible you will get a message similar to the following:

Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

One of the following options can be used to correct this issue:

1. Add the following line just below the [mysqld] line in the my.ini file (usually located in the folder where MySQL is installed):

   old-passwords

   Note: We recommended trying this option first.

   -or-

2. Update the passwords in the database to use the old format, rather than the new format - See: http://dev.mysql.com/doc/refman/4.1/en/old-client.html

   -or-

3. Upgrade PHP to version 5.0+, and ensure the mysqli extension is installed and is being used (change the database type to "mysqli" in config.php in AWM).

   Note: This option requires the latest version of PHP as well as MySQL.

The MySQL server will need to be restarted after any changes. In addition the awm_site users password might need to be reset.