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 :)

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Reddit
  • Twitter
  • Slashdot
  • StumbleUpon

Tags: , ,

Leave a Reply