Start script creates /var/run/mysqld with static owner

[Ignacio Huerta]

Binary package hint: mysql-server-5.1

I run a mysql server (5.1.37-1ubuntu5.1) in my laptop (Ubuntu Karmic 64) with my personal user "ignacio", instead of the default "mysql".

The problem: After defining the user on /etc/mysql/my.cnf and taking care of permissions, mysql server won't start.

The workaround: /etc/init.d/mysql script is the problem. I found out that on every start, the script creates /var/run/mysqld with the owner "mysql", and so the server doesn't start. After modifying this script (line 109), the server works perfectly.

The question: Maybe the mysql start script could check into /etc/mysql/my.cnf to see what the correct user is? Is there any reason why this mysqld folder is recreated on every reboot?

[Chuck Short (zulcss)]

Its something we can look at for lucid+1.

Regards
chuck