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

Tags: , ,

Debian sarge (3.1) repositories gone

Yes so the sarge repos is gone from all official debian mirrors.

Still got an old sarge box and want to install some packages?

Add this line to your /etc/apt/sources.list:

deb http://archive.debian.org/debian/ sarge main

And remove all the others.

Now do:
apt-get update

Now you should be able to install packages for your sarge. (But you really should upgrade due to big security risks!)

Tags: , , ,