Ubuntu
mysql-dfsg-5.0 package

  1. Bug #153221
  2. Comment #10

Comment 10 for bug 153221

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

OK, neither OLD_PASSWORD nor PASSWORD didn't produce good results. My mysql.user for debian-sys-maint looks not like this:

mysql> select User, Password, Host from user where User like 'debian%';
+------------------+-------------------------------------------+------+
| User | Password | Host |
 +------------------+-------------------------------------------+------+
| debian-sys-maint | *DCE05059E58FA45F45A40420DF3F02D16D103E73 | % |
 +------------------+-------------------------------------------+------+
1 row in set (0.00 sec)

It still fails to start, but, if I run mysqld by hand, I can log in without problems using same password I did hash from.

emil@heroina:/var/www/swatka$ mysql -p -u debian-sys-maint
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.45-Debian_1ubuntu2-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

I'm 99% sure now that there's a problem with upgrade scripts in package.