SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [grant table installation failed] >Description: Tried to install MYSQL using mysql-3.23.42-sun-solaris2.8-sparc.tar.gz following the instructions in the install-binary file. When I try to run the mysql_install_db script I get the following: # scripts/mysql_install_db ./bin/my_print_defaults: syntax error at line 1: `(' unexpected WARNING: The host 'cassini' 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 ./bin/mysqld: syntax error at line 1: `(' unexpected 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! Despite the message, there are no log files in the data folder!! I am logged in as root. >How-To-Repeat: <code/input/activities to reproduce the problem (multiple lines)> >Fix: <how to correct or work around the problem, if known (multiple lines)> >Submitter-Id: <submitter ID> >Originator: Super-User >Organization: <organization of PR author (multiple lines)> >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <synopsis of the problem (one line)> >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.42 (Official MySQL binary) >Environment: <machine, os, target, libraries (multiple lines)> System: SunOS cassini 5.8 Generic_108529-01 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/local/bin/perl /usr/xpg4/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-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 1573884 Mar 14 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 May 10 14:35 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 933184 Mar 14 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1573884 Mar 14 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 May 10 14:35 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 933184 Mar 14 2000 /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-assembler --disable-shared john gharagozlou consultant centrifusion 312-893- 8600 x8327 --------------------------------------------------------------------- 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