Mysql authentication backwards compability
Had an issue today where an old mysql-client on debian sarge failed to connect to a newer mysql-server on debian etch.
I was happy to find out that it’s easily fixed :
update mysql.user set password=OLD_PASSWORD('supahsecretpassword') where user='theuser' and host='some-ip-address';
then just :
flush privileges;
and you’re gooooood to goooooooooo