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]