MySQL new password problem
This morning is rich for troubles 
Some PHP script was to act with MySQL database, but it failed with: “Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL … Client does not support authentication protocol requested by server; consider upgrading MySQL client“.
I’ve digged a bit and solution was very simple -
SET PASSWORD FOR user@localhost = OLD_PASSWORD(‘newpassword’);
This updates password to use old authentication protocol.
Tuesday 03 Oct 2006 | Life, Coding, PHP, MySQL
