MySQL connection problems with Ubuntu

Thursday, March 23rd, 2006 at 1332

I 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.

One Comment for “MySQL connection problems with Ubuntu”

  1. EMmah Said this on

    If you/ve got a problem and no one else can help, maybe it’s time that you called THE A-TEAM

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>