Look again.
/usr/local/mysql is owned by root.
Mark Gillett wrote:
>Hi all,
>
>Have built mysql (mysql-3.23.49.tar.gz)
>
> --prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enable
>-assembler
>
>on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended
>patch level).
>
>The configure, make and install seemed to go ok and were done as root.
>
>I have run the ./scripts/mysql_install_db script and then (here comes the
>problem) tried to startup the server.
>
>cd /usr/local/mysql
>./bin/safe_mysqld --user=mysql &
>
>but the bad news is that it doesn't appear to work:
>
># Starting mysqld daemon with databases from /usr/local/mysql/var
>020814 12:00:18 mysqld ended
>
>when I look in the .err file (usr/local/mysql/var/hostname.domain.err), I
>see : (tail hostname.domain.err)
>
>---snip
>020814 11:28:44 mysqld started
>020814 11:28:44 /usr/local/mysql/libexec/mysqld: Can't create/write to file
>'/usr/local/mysql/var/hostname.domain.pid' (Errcode: 13)
>020814 11:28:44 /usr/local/mysql/libexec/mysqld: Can't find file:
>'./mysql/host .frm' (errno: 13)
>020814 11:28:44 /usr/local/mysql/libexec/mysqld: Error on delete of
>'/usr/local/mysql/var/hostname.domain.pid' (Errcode: 13)
>020814 11:28:44 mysqld ended
>----snip
>
>So I checked the ownership on the /usr/local/mysql/var directory etc:
>
> chgrp -R mysql /usr/local/mysql/var
> chown -R mysql /usr/local/mysql/var
>
>and ls -al shows that this lot seems ok :
>
>---snip
>total 28
>drw-rw-rw- 4 mysql mysql 512 Aug 14 11:27 .
>drwxr-xr-x 12 root mysql 512 Aug 14 10:12 ..
>-rw-rw-rw- 1 mysql mysql 4908 Aug 14 11:01 hostname-bin.001
>-rw-rw-rw- 1 mysql mysql 19 Aug 14 11:01 hostname-bin.index
>-rw-rw-rw- 1 mysql other 3124 Aug 14 11:28 hostname.domain.err
>drw-rw-rw- 2 mysql mysql 512 Aug 14 11:01 mysql
>drw-rw-rw- 2 mysql mysql 512 Aug 14 11:01 test
>---snip
>
>What am I missing ? Any ideas on the cause of this problem ?
>
>Thanks for your assistance (would be grateful for direct as well as list
>response as I am slower in wading through the lists than I would like!),
>
>Regards,
>
>Mark
>
>---
>
>Mark Gillett
>IXIF Limited
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread117056@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
