Leopard broke my mysql server

[Ryan Schmidt]

On Dec 23, 2007, at 19:16, Andre-John Mas wrote:

> I am using the mysql5 ports install as provided by macports. Since  
> having installed it I have now upgraded to Leopard. MacOS X 10.5  
> changes any daemon users to start with an underscore, such as  
> '_mysql' and this seems to be causing issues with the sql server,  
> giving me the following error in the system.log:
>
> Dec 23 20:13:07 Ghostwalker com.mysql.mysql[2608]: 071223 20:13:07   
> mysqld ended
> Dec 23 20:13:07 Ghostwalker com.apple.launchd[267]  
> (com.mysql.mysql): Throttling respawn: Will start in 8 seconds
> Dec 23 20:13:15 Ghostwalker com.mysql.mysql[2651]: Starting mysqld  
> daemon with databases from /opt/local/var/db/mysql5
> Dec 23 20:13:15 Ghostwalker com.mysql.mysql[2651]: rm: /opt/local/ 
> var/run/mysql5/mysqld.sock: Permission denied
> Dec 23 20:13:18 Ghostwalker com.mysql.mysql[2651]: STOPPING server  
> from pid file /opt/local/var/db/mysql5/Ghostwalker.local.pid
>
> What do I need to do to fix this? If the new nomenclature is to  
> have daemon users starting with underscores, then I don't wish to  
> go and change that, so there is probably something else I could be  
> changing. Note that I have changed the launchdaemon file
> 'com.mysql.mysql' to read:
>
> /opt/local/bin/mysqld_safe5 --user=_mysql
>
> but even after a restart this does not seem to have changed  
> anything, so any suggestions would be appreciated.

Sounds like you should file a ticket in the issue tracker and assign  
it to me, since I am the maintainer of the mysql5 port. Not that I  
know what I'm going to do about it yet, but that'll ensure the  
problem is not forgotten about.