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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php