MySQL connection problems with Ubuntu
Thursday, March 23rd, 2006 at 1332I 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.
If you/ve got a problem and no one else can help, maybe it’s time that you called THE A-TEAM