[arch-dev-public] problem with mysql rc script

[Jan de Groot]

On Fri, 2009-06-05 at 19:22 +0200, Pierre Schmitz wrote:
> Hi,
> 
> maybe someone has an idea how to solve http://bugs.archlinux.org/task/12798. 
> The proposed patch was added to mysql, reverted, re-added etc.. The current 
> version is broken again.
> 
> The problem is that the mysql rc script just checks for any process called 
> mysqld. But akonadi starts its own instance of mysql as user.
> 
> So if you use that rc script to start/stop mysql it woll kill akonadi's mysql 
> and not just its own.
> 
> I have no idea why using the pid saved by mysql did not work for some people.
> 
> So, any ideas are welcome.
> 
> Pierre

I usually shutdown mysql using "mysqladmin shutdown". This requires a
user account with shutdown rights. Debian installs such a user by
default, though I don't use any packages and use the root account for
that.