Make sure that mysql owns its files and directories.
Furmaniuk, Michael wrote:
> I've installed the Solaris 2.7 binary and am trying to connect to the
> database after doing the setup, when I attempt to start the database I get a
> message that mysql ended and there is no process started. I use the
> following (all things should be run with sudo on our server) -
>
>
>> sudo ./bin/safe_mysqld --user=mysql &
>
> [1] 23388
>
>> Starting mysqld daemon with databases from /usr/local/mysql/data
>
> 010613 10:26:06 mysqld ended
> [1] Done sudo ./bin/safe_mysqld --user=mysql
>
> Nothing is started and I find in the error log:
>
> 010613 10:26:06 mysqld started
> 010613 10:26:06 /usr/local/mysql/bin/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 010613 10:26:06 /usr/local/mysql/bin/mysqld: Normal shutdown
>
> 010613 10:26:06 /usr/local/mysql/bin/mysqld: Shutdown Complete
>
> 010613 10:26:06 mysqld ended
>
> I can see that host.frm exists, but I am not sure what is calling it, and
> from where since its listing the path name as relevant to mysql/bin but I
> can see it in:
>
>
>> sudo find / -name host.frm
>
> /usr/local/mysql/data/mysql/host.frm
>
> My info from mysqlbug is as follows:
>
>
>> Release: mysql-3.23.38 (Official MySQL binary)
>
>
>> Environment:
>
> <machine, os, target, libraries (multiple lines)>
> System: SunOS relpbld03 5.7 Generic_106541-10 sun4u sparc
> SUNW,UltraSPARC-IIi-cEngine
> Architecture: sun4
>
> Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
> GCC: Reading specs from
> /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
> CXXFLAGS='-O3 -fno-omit-frame-pointer -felid
> e-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
> LIBC:
> -rw-r--r-- 1 bin bin 1696732 May 10 2000 /lib/libc.a
> lrwxrwxrwx 1 root root 11 Jun 14 2000 /lib/libc.so ->
> ../libc.so.1
> -rwxr-xr-x 1 bin bin 1115336 May 10 2000 /lib/libc.so.1
> -rw-r--r-- 1 bin bin 1696732 May 10 2000 /usr/lib/libc.a
> lrwxrwxrwx 1 root root 11 Jun 14 2000 /usr/lib/libc.so ->
> ../libc.so.1
> -rwxr-xr-x 1 bin bin 1115336 May 10 2000 /usr/lib/libc.so.1
> Configure command: ./configure --prefix=/usr/local/mysql
> '--with-comment=Official MySQL binary' --with-extra-charsets=co
> mplex --with-server-suffix= --enable-assembler --disable-shared
> Perl: This is perl, version 5.005_03 built for sun4-solaris
>
> Am I missing something else or should I try to compile this from source?
>
> Thanks,
>
> Michael
>
> ---------------------------------------------------------------------
> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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