List:General Discussion« Previous MessageNext Message »
From:Van Date:March 14 1999 3:12pm
Subject:Re: File access problem
View as plain text  
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
=========================================================================



Thread
File access problemtymiwi14 Mar
  • File access problemMichael Widenius15 Mar
  • Re: File access problemVan15 Mar
    • returning table nameMarc Antony Vose15 Mar
      • returning table namesinisa16 Mar
        • Re: returning table nameThimble Smith16 Mar
Re: File access problemMikael Willberg15 Mar
Re: returning table nameefrazier16 Mar
  • Re: returning table nameThimble Smith16 Mar