>Description:
I am a new user to MySQL. When i try to create the MySQL grant tables, it does
not allow me to do that.
>How-To-Repeat:
This is the error message that i get when i run mysql_install_db
*****************************************************************
ld.so.1: ./bin/my_print_defaults: fatal: libz.so.1: open failed: No such file or
directory
WARNING: The host 'Explorer.ERC.MsState.Edu' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL deamon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory
Killed
Installation of grant tables failed!
Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
*****************************************************************
>Fix:
>Submitter-Id: Shravan Kumar Durvasula
>Originator:
>Organization:
>MySQL support: [email support]
>Synopsis: grant tables not created
>Severity: critical
>Priority: high
>Category: mysql
>Class: support
>Release: mysql-3.23.52 (Official MySQL binary)
>Environment:
System: SunOS Explorer.ERC.MsState.Edu 5.8 Generic_108528-15 sun4u sparc
SUNW,Ultra-5_10
Architecture: sun4
Some paths: /usr/bin/perl /usr/xpg4/bin//make /usr/local/gnu/bin/gmake
/usr/local/gnu/bin/gcc /opt/SUNWspro/bin/cc
GCC: Reading specs from /usr/local/gnu/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1764552 Jul 29 17:02 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jul 13 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1146204 Jul 29 17:02 /lib/libc.so.1
-rw-r--r-- 1 root bin 1764552 Jul 29 17:02 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jul 13 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1146204 Jul 29 17:02 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared
CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti' CXX=gcc
---------------------------------------------------------------------
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
