MySQL 4.1 - Installation of grant tables failed
hi, I have the same problem with executing mysql_install_db in mysql 4.1 after compiling it on debian 3.0, lust like Bug #2915 installation of grant tables failed! after sucessfully configure (./configure --prefix=/usr/local/mysql --with-innodb) make make install and executing mysql_install_db as root, I got the error: make[3]: Leaving directory `/files/mysql-4.1.1-alpha/support-files' make[2]: Leaving directory `/files/mysql-4.1.1-alpha/support-files' make[1]: Leaving directory `/files/mysql-4.1.1-alpha/support-files' neptun:/files/mysql-4.1.1-alpha# scripts/mysql_install_db Installing all prepared tables ERROR: 1064 You have an error in your SQL syntax. Check the manual that corres ND(expr)\nReturns the bitwise AND of all bits in expr. The calculation ' at line 040221 14:46:17 Aborting 040221 14:46:17 /usr/local/mysql/libexec/mysqld: Shutdown Complete Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: ... ... Is it a bug or have I made the same error as in Bug #2915? I would be happy, if anybody could help me. kind regards Sabine Seipel -- GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...) jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ http://www.gmx.net/derspiegel +++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Installation of grant tables failed!]
Description: /usr/local/mysql/bin # cd .. # ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 011121 20:15:29 Warning: setrlimit couldn't increase number of open files to more than 60 011121 20:15:29 Warning: Changed limits: max_connections: 50 table_cache: 64 ./scripts/mysql_install_db[292]: 15249 Memory fault(coredump) Installation of grant tables failed! Submitter-Id: [EMAIL PROTECTED] Originator: Organization: organization of PR author (multiple lines) MySQL support: [none |] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.44 (Official MySQL binary) Environment: System: HP-UX leonardo B.10.20 A 9000/871 2014209786 two-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Jun 10 1996 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Jun 10 1996 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --with-pthread --with-lib-ccflags=-fpic --with-named-thread-libs=-ldce --disable-shared - 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
Installation of grant tables failed
Description: I've tried to install MySQL-2.23.37 on LinuxPPC dr4 (not a recent distribution, I know that...), from the source code (mysql-3.23.37.tar.gz). unzip of the file was successfull, configuration and compilation seem to have worked fine, but the installation of the grant tables failed, and returned the following message: [root@localhost mysql-3.23.37]# sh .scripts/mysql_install_db --log Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths.Using --log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about MySQL is available on the web at ... etc... The log file was not much more explicit : /usr/local/mysql/libexec/mysqld, Version: 3.23.37-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id CommandArgument At least, I would like to know what does 'mysqld got signal 11;' means, or refers to !! Thanks for help How-To-Repeat: sources of MySQL in /root [root@localhost root]# gunzip -c mysql-3.23.37.tar.gz | tar xf - [root@localhost root]# cd mysql-3.23.37 [root@localhost mysql-3.23.37]# /sbin/groupadd mysql [root@localhost mysql-3.23.37]# /sbin/useradd -g mysql mysql [root@localhost mysql-3.23.37]# ./configure --prefix=/usr/local/mysql --with-low-memory [root@localhost mysql-3.23.37]# make ; make install [root@localhost mysql-3.23.37]# sh .scripts/mysql_install_db --log here, I get message saying that mysqld got signal 11, and that installation of grant tables failed Fix: Submitter-Id: KLEGOU stéphane Originator:root Organization:Personnal user MySQL support: none Synopsis: 'mysqld got signal 11;' when I've tried to install the grant tables with the command-line 'sh .scripts/mysql_install_db --log', and installation of grant tables failed. Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.37 (Source distribution) Environment: PowerMacintosh 5500/275 MacOS 8.1 System: Linux localhost.localdomain 2.2.1 #101 Fri Feb 5 16:17:12 EST 1999 ppc unknown Architecture: ppc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /opt/egcs/lib/gcc-lib/powerpc-unknown-linux-gnulibc1/egcs-2.90.25/specs gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 12 Nov 1 00:46 /lib/libc.so.6 - libc-1.99.so -rwxr-xr-x 1 root root 909419 Jun 16 1998 /lib/libc-1.99.so -rw-r--r-- 1 root root 1672250 Jun 16 1998 /usr/lib/libc.a -rwxr-xr-x 1 root root 332 Jun 16 1998 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --with-low-memory Perl: This is perl, version 5.004_01 - 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
Installation of grant tables failed!?
I need help with this issue. We decompressed a mysql archive on a Solaris box with gnu tar and tried to run this script ./configure --prefix=/usr/local/mysql but was unsuccessful and received this error. 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: libcrypt_i.so.1: open failed: No such file or dire ctory 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! your help would greatly be appreciated, John