MySQL connection problems with Ubuntu
Thursday 1332hrsI just discovered after a lot of pissing around and timewasting (Note, time that I absolutely cannot afford to waste right now) that Ubuntu Hoary and MySQL5 runs with old password hashing enabled by default in the my.cnf file (/etc/mysql/my.cnf)
Line 43 or thereabouts.
If you’ve had trouble with new things being able to connect to MySQL databases on Ubuntu, then this may be a likely culprit. All users created will have the shorter 16 byte password hashes instead of the newer ones.
Annoying to discover this now.