[debian-mysql] Bug#737224: mysql-server-5.5: upgrade create mysql tables as root

[Akhil Mohan]

Hi Clint,

I built from the GIT repo for MySQL 5.5 and everything works really fine
after the patch has been applied.
All the files are created with ownership mysql:mysql under data dir.
Rest of the server also installed correctly and is running absolutely fine.

Adding the file listing here for reference.

root at Arjuna-Alpha:/home/andra# ls -ld /var/lib/mysql
drwx------ 4 mysql mysql 4096 Feb  6 13:30 /var/lib/mysql

root at Arjuna-Alpha:/home/andra# ls -l /var/lib/mysql/
total 28684
-rw-r--r-- 1 root  root         0 Feb  6 13:30 debian-5.5.flag
-rw-rw---- 1 mysql mysql 18874368 Feb  6 13:30 ibdata1
-rw-rw---- 1 mysql mysql  5242880 Feb  6 13:30 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 Feb  6 13:30 ib_logfile1
drwx------ 2 mysql root      4096 Feb  6 13:30 mysql
-rw------- 1 root  root         6 Feb  6 13:30 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Feb  6 13:30 performance_schema

Regards,
Akhil

On Friday 31 January 2014 10:28 PM, Clint Byrum wrote:
> Thanks Ghislain. A fix is committed to the mysql-5.5 package repository.
>
> It would be great if somebody could build from the git repo and confirm
> that this problem is fixed (and that it doesn't regress anything). I
> just don't have the time right now unfortunately.
>
>