[CentOS] Mysql login-problem after recent 4.1.20 upgrade (CentOS4.3, x86_64)

Sat Jun 10 14:17:51 UTC 2006
Simen Thoresen <simentt at dolphinics.no>

Hi all,

I've upgraded my mysql-installation from the previous 4.1.12 version to the 
new 4.1.20 version, and I've found that a daemon I'm using suddenly can't 
log into the database anymore.

I've verified the problem with the mysql command;
[root at sciream ~]# mysql -upostfix -p mysql
Enter password:
ERROR 1045 (28000): Access denied for user 'postfix'@'localhost' (using 
password: YES)
[root at sciream ~]#

I've changed the users password in the mysql database to make sure the 
encrypted version is compatible with the current server, but to no avail

Rolling back to the 4.1.12 version fixed it for me (if not, I'd still be 
sweating about this ;-), but I hope this mail comes in time to assist others.

# rpm -Uvh --oldpackage mysql-4.1.12-3.RHEL4.1.* \
mysql-server-4.1.12-3.RHEL4.1.x86_64.rpm \
mysql-devel-4.1.12-3.RHEL4.1.x86_64.rpm

fixed it again.

This was with a current CentOS 4.3 install, running in x86_64 mode. Can 
anyone confirm this?

I'll see if I can do this on i386 as well.

Yours,
-S
-- 
Simen Thoresen, Dolphin ICS