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@sciream ~]# mysql -upostfix -p mysql Enter password: ERROR 1045 (28000): Access denied for user 'postfix'@'localhost' (using password: YES) [root@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