MySQL Bugs: #2915: installation of grant tables failed!

Bug #2915	installation of grant tables failed!
Submitted:	21 Feb 2004 6:21	Modified:	18 May 2004 18:11
Reporter:	[ name withheld ]	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	4.1.1alpha	OS:	Linux (Debian Linux 3.0)
Assigned to:		CPU Architecture:	Any

Description:
After compiling the current mysql 4.1.1alpha version on my debian linux 3.0 with ./configure --prefix=/usr/local/mysql --with-innodb and make & make install, I want to installing the grant tables with usual command: scripts/mysql_install_db
after that, I got the following error:

make[3]: Leaving directory `/install/mysql-4.1.1-alpha/support-files'
make[2]: Leaving directory `/install/mysql-4.1.1-alpha/support-files'
make[1]: Leaving directory `/install/mysql-4.1.1-alpha/support-files'
nexus:/install/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:

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
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 /usr/local/mysql/bin/mysqlbug script!

I think that is bug, because with the same procedure I sucessfully install mysql 4.0 pretty often.

How to repeat:
install the official mysql 4.1.1 alpha (no snapshot) on a linux debian 3.0 OS Linux 2.2.20-idepci i686 unknown

Please upload your mysql_install_db file that you have been using.

mysql_install_db file from my mysql-4.1.1alpha installation

Attachment: mysql_install_db (text/plain), 7.90 KiB.

okay, mysql_install_db file attached

This is already fixed in 4.1.2 which will be out in two weeks.

19th now - that's a long two weeks

This bug is a bit of a blocker, you know? Especially with me being a feeb who needs to have his hand held - I can't even get the server running.

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

see http://bugs.mysql.com/2872

In a fresh install of todays "Standard 4.0.24" for Linux (running on SuSE 9.2) I get this error when running mysql_install_db like recommended in the file INSTALL-BINARY.
Same procedure I tested on "Max 4.1.11"; it works fine. But I need an 4.0-Version of mysql.

linux:/XMendel/bin/mysql # ./scripts/mysql_install_db --user=mysql
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1064  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lock' at line 1
050503 17:31:19 Aborting

050503 17:31:19 ./bin/mysqld: Shutdown Complete

Installation of grant tables failed!

Examine the logs in ./data for more information.