Re: [PLUG] Looking for a good open source CRM

[Warwick Poole <plug@linuxinternet.org>]

I ran into a very similar issue with PHP, not Perl. Many people have
been hitting this issue with the newer release of MySQL. Its outlined
here:
http://www.php-forum.com/p/viewtopic.php?p=21109

If it is the same problem that I had (very likely): essentially, while
you may have the newest MySQL client on your OS, PHP, or in your case,
DBI, is still trying to authenticate to MySQL using the old (ie 4.0)
style password hashes. MySQL 4.1 and above use new password styles. You
can fix this by reencoding the passwords already in MySQL by doing:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') 
-> WHERE Host = 'some_host' AND User = 'some_user'; 
mysql> FLUSH PRIVILEGES;

Hope that fixes your issues. It fixed mine.

Warwick.

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug