>Description: running mysql_install_db does not correctly fill grant tables >How-To-Repeat: run mysql_install_db; attempt to connect, fail. >Fix: Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL**
>Submitter-Id: [EMAIL PROTECTED] >Originator: Adam Thompson >Organization: athompso.net >MySQL support: none >Synopsis: Solaris 10 /bin/sh inadequate to run mysql_install_db >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-5.1.30 (MySQL Community Server (GPL)) >Server: /bin/mysqladmin Ver 8.42 Distrib 5.1.30, for sun-solaris2.10 on sparc Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. 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.1.30 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 49 sec Threads: 1 Questions: 3 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.61 >C compiler: >C++ compiler: CC: Sun C++ 5.9 SunOS_sparc Patch 124863-08 2008/10/16 >Environment: <machine, os, target, libraries (multiple lines)> System: SunOS e450 5.10 Generic_137137-09 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /bin/perl /usr/xpg4/bin/make /usr/sfw/bin/gmake /usr/sfw/bin/gcc GCC: Reading specs from /usr/sfw/lib/gcc/sparc-sun-solaris2.10/3.4.3/specs Configured with: /sfw10/builds/build/sfw10-patch/usr/src/cmd/gcc/gcc-3.4.3/configure --prefix=/usr/sfw --with-as=/usr/ccs/bin/as --without-gnu-as --with-ld=/usr/ccs/bin/ld --without-gnu-ld --enable-languages=c,c++ --enable-shared Thread model: posix gcc version 3.4.3 (csl-sol210-3_4-branch+sol_rpath) Compilation info (call): CC='/opt/studio12/SUNWspro/bin/cc' CFLAGS='-g -xO2 -Xa -xstrconst -mt -D_FORTEC_ -m64' CXX='/opt/studio12/SUNWspro/bin/CC' CXXFLAGS='-g -xO2 -noex -mt -D_FORTEC_ -m64' LDFLAGS='-m64' ASFLAGS='-m64' Compilation info (used): CC='/opt/studio12/SUNWspro/bin/cc' CFLAGS=' -g -xO2 -Xa -xstrconst -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T -DUNIV_SOLARIS' CXX='/opt/studio12/SUNWspro/bin/CC' CXXFLAGS=' -g -xO2 -noex -mt -D_FORTEC_ -m64 -DHAVE_RWLOCK_T' LDFLAGS='-m64 ' ASFLAGS='-m64' LIBC: lrwxrwxrwx 1 root root 9 Dec 1 01:40 /lib/libc.so -> libc.so.1 -rwxr-xr-x 1 root bin 1629616 Oct 3 16:37 /lib/libc.so.1 lrwxrwxrwx 1 root root 19 Dec 1 01:39 /usr/lib/libc.so -> ../../lib/libc.so.1 lrwxrwxrwx 1 root root 19 Dec 1 01:39 /usr/lib/libc.so.1 -> ../../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 Server (GPL)' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--with-mysqld-libs=-lmtmalloc' '--with-named-z-libs=no' '--with-pic' '--with-client-ldflags=-static' '--with-mysqld-ldflags=-static' '--with-zlib-dir=bundled' '--with-big-tables' '--with-ssl' '--with-readline' '--with-embedded-server' '--with-partition' '--with-innodb' '--without-ndbcluster' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--with-csv-storage-engine' '--without-example-storage-engine' '--with-federated-storage-engine' '--with-extra-charsets=complex' 'CC=/opt/studio12/SUNWspro/bin/cc' 'CFLAGS=-g -xO2 -Xa -xstrconst -mt -D_FORTEC_ -m64' 'LDFLAGS=-m64' 'CXX=/opt/studio12/SUNWspro/bin/CC' 'CXXFLAGS=-g -xO2 -noex -mt -D_FORTEC_ -m64' -- -Adam Thompson <[EMAIL PROTECTED]>