>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'
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]