>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]>
