From: Van
Date: March 14 1999 3:12pm
Subject: Re: File access problem
List-Archive: http://lists.mysql.com/mysql/233
Message-Id: <36EBD1F9.918CBDEB@dedserius.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

tymiwi@stripped wrote:

> >Description:
>
> Directory layout and permissions on my test system are:
>
> # mysql home
> drwxr-x---  12 root     sql          1024 Mar 14 06:18 /home/sql/
>
> # the storage for databasese
> drwxr-x---   4 sql      sql          1024 Mar 14 08:28 /home/sql/var/
>
> # all other directories are like this one
> drwxr-xr-x   3 root     root         1024 Mar 14 06:14 share
>
> When the server is started with parameter "--user=sql" the following
> error appears in error log:
>
> 990314 8:23:48 /data/home/sql/libexec/mysqld: Can't create/write to
> file '/home/sql/var/mysqld.pid' (Errcode: 13)
>

My perms:

drwxr-xr-x  21 mysql    root         1024 Mar 12 15:40 var/

drwxr-xr-x   2 mysql    root         1024 Mar 11 21:38 mysql/

-rw-rw----   1 mysql    root     24837398 Mar 14 10:09 tempe.log

-rw-r--r--   1 mysql    root            5 Mar 12 15:40 tempe.pid

To start mysql:

/usr/local/libexec/mysqld --user=mysql -l/usr/local/var/tempe.log &

Regards,

Van

--
=========================================================================
Linux rocks!!!   www.dedserius.com
=========================================================================