[debian-mysql] Each mysql install lead to file owned by root instead of 'mysql' in /var/lib/mysql

[Ghislain]

hello there,

   I encountered a recurring bug on upgrade of the debian package of mysql.

   Each time i upgrade mysql on a debian server i end with various files 
owned by root.

   Here:

Start-Date: 2013-12-18  07:39:09
Commandline: apt-get upgrade
Upgrade: mysql-server:amd64 (5.5.31+dfsg-0+wheezy1, 
5.5.33+dfsg-0+wheezy1), mysql-server-core-5.5:amd64 
(5.5.31+dfsg-0+wheezy1, 5.5.33+dfsg-0+wheezy1), libnspr4:amd64 (4.9.2-1, 
4.9.2-1+deb7u1), mysql-server-5.5:amd64 (5.5.31+dfsg-0+wheezy1, 
5.5.33+dfsg-0+wheezy1)
End-Date: 2013-12-18  07:39:31



result:

/root%(root)> find /var/lib/mysql/ ! -user mysql -ls
131126    4 drwx------   2 root     root         4096 Dec 18 07:39 
/var/lib/mysql/performance_schema
131173   12 -rw-rw----   1 root     root         9220 Dec 18 07:39 
/var/lib/mysql/performance_schema/events_waits_history_long.frm
131182   12 -rw-rw----   1 root     root         8854 Dec 18 07:39 
/var/lib/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm
131227   12 -rw-rw----   1 root     root         8776 Dec 18 07:39 
/var/lib/mysql/performance_schema/performance_timers.frm
131150   12 -rw-rw----   1 root     root         8624 Dec 18 07:39 
/var/lib/mysql/performance_schema/cond_instances.frm
131216   12 -rw-rw----   1 root     root         8654 Dec 18 07:39 
/var/lib/mysql/performance_schema/file_instances.frm
131287   12 -rw-rw----   1 root     root         8650 Dec 18 07:39 
/var/lib/mysql/performance_schema/threads.frm
131274   12 -rw-rw----   1 root     root         8605 Dec 18 07:39 
/var/lib/mysql/performance_schema/setup_consumers.frm
131225   12 -rw-rw----   1 root     root         8840 Dec 18 07:39 
/var/lib/mysql/performance_schema/file_summary_by_instance.frm
131133    4 -rw-rw----   1 root     root           61 Dec 18 07:39 
/var/lib/mysql/performance_schema/db.opt
131200   12 -rw-rw----   1 root     root         8814 Dec 18 07:39 
/var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm
131169   12 -rw-rw----   1 root     root         9220 Dec 18 07:39 
/var/lib/mysql/performance_schema/events_waits_history.frm
131180   12 -rw-rw----   1 root     root         8878 Dec 18 07:39 
/var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm
131284   12 -rw-rw----   1 root     root         8650 Dec 18 07:39 
/var/lib/mysql/performance_schema/setup_timers.frm
131232   12 -rw-rw----   1 root     root         8758 Dec 18 07:39 
/var/lib/mysql/performance_schema/rwlock_instances.frm
131222   12 -rw-rw----   1 root     root         8800 Dec 18 07:39 
/var/lib/mysql/performance_schema/file_summary_by_event_name.frm
131226   12 -rw-rw----   1 root     root         8684 Dec 18 07:39 
/var/lib/mysql/performance_schema/mutex_instances.frm
131154   12 -rw-rw----   1 root     root         9220 Dec 18 07:39 
/var/lib/mysql/performance_schema/events_waits_current.frm
131281   12 -rw-rw----   1 root     root         8637 Dec 18 07:39 
/var/lib/mysql/performance_schema/setup_instruments.frm


  so i wanted to report it to you as i encountered this a lot especialy 
when i upgrade from a debian version to the other most of the time the 
upgrade just break beacause of the mysql package not able to restart 
mysql correctly after the upgrade because of owner issues.

best regards,
Ghislain.