3 messages in com.mysql.lists.mysqlPermissions for /var/run/mysqld
FromSent OnAttachments
Norman Walsh19 Feb 2006 12:02 
sheeri kritzer20 Feb 2006 09:56 
Norman Walsh22 Feb 2006 09:06 
Subject:Permissions for /var/run/mysqld
From:Norman Walsh (nd@nwalsh.com)
Date:02/19/2006 12:02:14 PM
List:com.mysql.lists.mysql

A couple of days ago, I decided to be brave (or crazy :-) and upgrade my Ubuntu "Breezy" install to "Dapper". It was really remarkably uneventful, I've just got a couple of rough edges to sort out.

One is that dspam (3.4.9 built by me some months ago) can no longer connect to mysql when I reboot the machine. The problem appears to be permissions related. On boot, /var/run/mysqld is owned by mysql and in the root group with 770 permissions. That means that dspam can't open /var/run/mysqld/mysqld.sock to connect to the database.

I've been fixing the problem with

chgrp mysql /var/run/mysqld chmod 775 /var/run/mysqld

but (1) is that the safe and correct thing to do and (2) if it is, how can I get mysql to do that by default when it starts?

Be seeing you, norm