Ubuntu
mysql-dfsg-5.0 package

  1. Bug #153221
  2. Comment #7

Comment 7 for bug 153221

Revision history for this message
Emil Oppeln-Bronikowski (opi) wrote : Re: MySQL server fails to upgrade in Gutsy

Ho hum! It seems that after all my mysql.user Password field was different from /etc/mysql/debian.cnf. I've updated password string.

mysql> SELECT Host,User,Password FROM user WHERE User = 'debian-sys-maint';
+-----------+------------------+------------------+
| Host | User | Password |
 +-----------+------------------+------------------+
| localhost | debian-sys-maint | 69006d5d4d87514c |
 +-----------+------------------+------------------+
1 row in set (0.00 sec)

root@heroina:~# cat /etc/mysql/debian.cnf | grep password
password = 69006d5d4d87514c
password = 69006d5d4d87514c

And now... MySQL won't even start.

root@heroina:~# /etc/init.d/mysql start
 * Starting MySQL database server mysqld [ OK ]
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

I wonder if that's somehow related to Host field. Maybe I'll change its value to '%'. About logs, same as in Shot comment before, /var/log/mysql.err and .log are empty. Binlogs are also quiet.