That error is related to MySQL and the MySQL connector that PHP is using. You will need to alter the passwords in your mysql system schema (‘database’) so that they use the old encryption technique.
Short version:
– Login using the mysql.exe in the MySQL server/bin/ through the command prompt: “mysql -u root -p”. If you are in a hosted environment you’ll have to use phpmyadmin or ask the technical support.
– Enter your password
– You will get a mysql prompt like ‘mysql>’
– “USE mysql”
– “SELECT User, Host, Password FROM user;” You will see a list of the current users, hosts and their password hash.
– For your ‘wordpress’@’localhost’ and the other ones that need to connect to your database through php, do this:
“SET PASSWORD FOR ‘wordpress’@’localhost’ = OLD_PASSWORD(‘newpasswordhere’);”
For more information search https://dev.mysql.com/doc for the function OLD_PASSWORD.
Good luck…
