[debian-mysql] Bug#555803: mysql-server install does not contain root mysql user

[Étienne Loks]

Package: mysql-server
Version: 5.1.49-3
Severity: normal

I have the same issue.
First permissions were first badly set for /tmp.
But after fix of the permissions, purge and reinstall the package, the root
mysql user is not created.

lysithea:/# ls -l
total 84
drwxr-xr-x   2 root root  4096 30 mars  23:44 bin
drwxr-xr-x   3 root root  4096 27 juin  12:06 boot
drwxr-xr-x  14 root root  2700 11 déc.   2010 dev
drwxr-xr-x  82 root root  4096 25 août  10:26 etc
drwxr-xr-x   6 root root  4096 22 août  12:39 home
lrwxrwxrwx   1 root root    30 11 déc.   2010 initrd.img -> boot/initrd.img-2.6.32-5-amd64
drwxr-xr-x  10 root root 12288 24 août  19:53 lib
lrwxrwxrwx   1 root root     4 11 déc.   2010 lib64 -> /lib
drwx------   2 root root 16384 11 déc.   2010 lost+found
drwxr-xr-x   3 root root  4096  9 févr.  2009 media
drwxr-xr-x   2 root root  4096  4 déc.   2008 mnt
drwxr-xr-x   2 root root  4096  9 févr.  2009 opt
dr-xr-xr-x 116 root root     0 11 déc.   2010 proc
drwx------   7 root root  4096 25 août  10:27 root
drwxr-xr-x   2 root root  4096 27 juin  12:05 sbin
drwxr-xr-x   2 root root  4096 16 sept.  2008 selinux
drwxr-xr-x   4 root root  4096 24 août  19:56 srv
drwxr-xr-x  13 root root     0 11 déc.   2010 sys
drwxrwxrwt   7 root root  4096 25 août  10:35 tmp
drwxr-xr-x  10 root root  4096  9 févr.  2009 usr
drwxr-xr-x  14 root root  4096 11 déc.   2010 var
lrwxrwxrwx   1 root root    27 11 déc.   2010 vmlinuz -> boot/vmlinuz-2.6.32-5-amd64

lysithea:/# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
lysithea:/# /usr/bin/mysqld_safe --skip-grant-tables &
[1] 31724
lysithea:/# 110825 10:49:51 mysqld_safe Logging to syslog.
110825 10:49:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

lysithea:/# mysql --user=root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select Host, User from user;
+-----------+------------------+
| Host      | User             |
+-----------+------------------+
| localhost | debian-sys-maint |
+-----------+------------------+
1 row in set (0.00 sec)



-- System Information:
Debian Release: 6.0.2
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (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/dash

Versions of packages mysql-server depends on:
ii  mysql-server-5.1              5.1.49-3   MySQL database server binaries and

mysql-server recommends no packages.

mysql-server suggests no packages.

-- no debconf information