Subject: Re: /var/mysql/ permissions
To: Dan <kasper37@netzero.com>
From: Adrian Portelli <adrian.p@bigpond.net.au>
List: tech-pkg
Date: 03/27/2003 19:11:11
Check the MESSAGE that comes with mysql-server:

The MySQL directory `${MYSQL_DATADIR}' should be owned by the
user `${MYSQL_USER}' and group `${MYSQL_GROUP}'.  This can be done with:
        chown -R ${MYSQL_USER}:${MYSQL_GROUP} ${MYSQL_DATADIR}

You need to set the permissions manually as a post-installation task.

Adrian.

On Wed, Mar 26, 2003 at 11:39:45PM -0800, Dan wrote:
> After a simple make install in mysql-server I did this:
> 
> --------------------------------------
> bash-2.05b# /etc/rc.d/mysqld start
> Starting mysqld.
> bash-2.05b# mysqldump -A >backupdump.sql
> mysqldump: Got error: 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (61) when trying to connect
> bash-2.05b# cd /var/mysql/
> bash-2.05b# cat test2.testsystem.com.err
> 033826 15:38:13  Starting mysqld daemon with databases from /var/mysql
> 033826 15:38:13  mysqld started
> 030326 15:38:13  /usr/pkg/libexec/mysqld: Can't find file: './mysql/host.frm'
> (errno: 13)
> 033826 15:38:13  mysqld ended
> bash-2.05b# chown -R mysql mysql/
> bash-2.05b# chown -R mysql test/
> bash-2.05b# /etc/rc.d/mysqld start
> Starting mysqld.
> bash-2.05b# mysqldump -A >backupdump.sql
> bash-2.05b#
> --------------------------------------
> 
> Am I doing something wrong or are those directories not chowned to the correct
> user on install?
> 
> Dan