[debian-mysql] Bug#511420: mysql-server-5.0: No root user created after install

[Marc MAURICE]

Package: mysql-server-5.0
Version: 5.0.51a-20
Severity: grave
Justification: renders package unusable


Hi,

I'm installing mysql-server-5.0 on a fresh debootstrap debian version.

After installing the package, I was not able to login with root user, 
because the root user
is not present in the mysql.user table.

# mysql -u debian-sys-maint -p mysql -e "select host,user from user"
Enter password:
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | debian-sys-maint |
+-----------+------------------+
#

As you see, only debian-sys-maint user is created.

I also tried purging the package and installing it again.

Am I missing something ?

Thanks in advance,

Marc


-- System Information:
Debian Release: 5.0
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.26-1-686 (SMP w/1 CPU core)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.110             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.24            Debian configuration 
management sy
ii  libc6                  2.7-16            GNU C Library: Shared libraries
ii  libdbi-perl            1.605-1           Perl5 database interface by 
Tim Bu
ii  libgcc1                1:4.3.2-1.1       GCC support library
ii  libmysqlclient15off    5.0.51a-20        MySQL database client library
ii  libncurses5            5.7+20081213-1    shared libraries for 
terminal hand
ii  libreadline5           5.2-3             GNU readline and history 
libraries
ii  libstdc++6             4.3.2-1.1         The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-16          Wietse Venema's TCP 
wrappers libraii  lsb-base               3.2-20            Linux 
Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-20        MySQL database client binaries
ii  mysql-common           5.0.51a-20        MySQL database common files
ii  passwd                 1:4.1.1-6         change and administer 
password and
ii  perl                   5.10.0-18         Larry Wall's Practical 
Extraction
ii  psmisc                 22.6-1            Utilities that use the proc 
filesy
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
pn  libhtml-template-perl         <none>     (no description available)
pn  mailx                         <none>     (no description available)

Versions of packages mysql-server-5.0 suggests:
pn  tinyca                        <none>     (no description available)

-- debconf information:
* mysql-server/root_password_again: (password omitted)
* mysql-server/root_password: (password omitted)
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true
  mysql-server/password_mismatch: