List:General Discussion« Previous MessageNext Message »
From:Rick Pelleg Date:December 23 2006 5:50am
Subject:mysql_install_db does not use correct datadir
View as plain text  
>Description:
I downloaded mysql-standard-5.0.27-solaris8-sparc-64bit.pkg from the
MySQL
site, and installed it by a default pkgadd - it installed itself under 
/opt/mysql/mysql.
 
I then ran mysql_install_db as root with single option --user=mysql, and
then tried mysqld_safe but it failed.
So I ran it again with:
bin/mysqld_safe --user=mysql --verbose --log-error=/tmp/mysql.error.log
and saw that the problem was:
Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
 
>How-To-Repeat:
See Description.
>Fix:
I re-ran mysql_install_db with explicit datadir setting:
mysql_install_db --user=mysql --datadir=/opt/mysql/mysql/data
 
>Submitter-Id: unknown
>Originator: 
>Organization:
Personeta, Let.
>MySQL support: none
>Synopsis: mysql_install_db does not use correct datadir
>Severity: serious
>Priority: medium
>Category: mysql
>Class:  doc-bug
>Release: mysql-5.0.27-standard (MySQL Community Edition - Standard
(GPL))
>Server: /usr/bin/mysqladmin  Ver 8.41 Distrib 5.0.27, for
sun-solaris2.8 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
 
Server version  5.0.27-standard
Protocol version 10
Connection  Localhost via UNIX socket
UNIX socket  /tmp/mysql.sock
Uptime:   3 min 4 sec
 
Threads: 1  Questions: 1  Slow queries: 0  Opens: 12  Flush tables: 1
Open tables: 6  Queries per second avg: 0.005
>C compiler:    
>C++ compiler:  CC: Sun C++ 5.6 2004/07/15
>Environment:
System: SunOS lyra 5.8 Generic_108528-22 sun4u sparc SUNW,Sun-Fire-V240
Architecture: sun4
 
Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/opt/SUNWspro/bin/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='cc-5.0'  CFLAGS='-xO3 -Xa -xstrconst -mt
-D_FORTEC_ -xarch=v9'  CXX='CC'  CXXFLAGS='-xO3 -noex -mt -D_FORTEC_
-xarch=v9'  LDFLAGS='-xarch=v9'  ASFLAGS='-xarch=v9'
LIBC: 
-rw-r--r--   1 root     bin      1788708 May 10  2003 /lib/libc.a
lrwxrwxrwx   1 root     root          11 Feb 23  2004 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x   1 root     bin      1157924 May 10  2003 /lib/libc.so.1
-rw-r--r--   1 root     bin      1788708 May 10  2003 /usr/lib/libc.a
lrwxrwxrwx   1 root     root          11 Feb 23  2004 /usr/lib/libc.so
-> ./libc.so.1
-rwxr-xr-x   1 root     bin      1157924 May 10  2003 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data'
'--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community
Edition - Standard (GPL)' '--with-server-suffix=-standard'
'--enable-thread-safe-client' '--enable-local-infile'
'--with-named-curses-libs=-lcurses' '--with-named-z-libs=no'
'--with-pic' '--disable-shared' '--with-zlib-dir=bundled'
'--with-low-memory' '--with-big-tables' '--with-yassl' '--with-readline'
'--with-archive-storage-engine' '--with-innodb'
'--with-extra-charsets=complex' 'CC=cc-5.0' 'CFLAGS=-xO3 -Xa -xstrconst
-mt -D_FORTEC_ -xarch=v9' 'CXXFLAGS=-xO3 -noex -mt -D_FORTEC_ -xarch=v9'
'CXX=CC' 'LDFLAGS=-xarch=v9'
 
Thread
mysql_install_db does not use correct datadirRick Pelleg23 Dec