Package: libmysqlclient 3.23.49-8.9 and/or mysql-common and/or mysql-client and/or mysql-server
Version: 3.23.49-8.9
Description:
After updating from version 3.23.49-8.8 to 3.23.49-8.9 of packages libmysqlclient, mysql-common and mysql-client I found that I could no longer autheticate as a particular user. Previously I could authenicate use the command:
$ mysql -h 127.0.0.1 -u username -pPASSWORD mydatabase
mysql> quit
After applying the update I found that running the same command resulted in the
an authenication failure.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
This also affected services logging into this mysql database as this user (I
have a database which contains details of mail accounts which is used by postfix
and courier).
To resolve the problem I simply gave permission for the user to connect from
'hostname' as well as localhost. However I did not expect an update such as
this to result in a change in the manner that mysql handled authenticatation.
System details:
$ uname -a
Linux seagull.axial.net.au 2.4.18-1-686 #1 Wed Apr 14 18:20:10 UTC 2004 i686 unknown
$ dpkg -s libc6 | grep ^Version
Version: 2.2.5-11.8
/var/log/mail.log
Jan 20 18:17:03 hostname postfix/trivial-rewrite[1508]: warning: connect
to mysql server 127.0.0.1: Access denied for user: '@hostname' to
database 'database'
Jan 20 18:17:04 hostname authdaemond.mysql: authmysql: mysql_select_db(maildb)
error: Access denied for user: '@hostname' to database 'database'
/var/log/mysql.log
050120 17:06:54 9 Connect [EMAIL PROTECTED] as anonymous on database
9 Init DB Access denied for user: '@hostname' to
database 'hostname'
10 Connect [EMAIL PROTECTED] as anonymous on database
10 Init DB Access denied for user: '@hostname' to
database 'hostname'
11 Connect [EMAIL PROTECTED] as anonymous on database
11 Init DB Access denied for user: '@hostname' to
database 'hostname'
12 Connect [EMAIL PROTECTED] as anonymous on database
12 Init DB Access denied for user: '@hostname' to
database 'hostname'
/etc/mysql/my.conf
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock
[safe_mysqld] err-log = /var/log/mysql/mysql.err
[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 log = /var/log/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-locking skip-innodb
[mysqldump] quick set-variable = max_allowed_packet=1M
[mysql]
[isamchk] set-variable = key_buffer=16M
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
