MySQL Bugs: #35773: --disable-grant-options and mysql_install

Bug #35773	--disable-grant-options and mysql_install_db
Submitted:	2 Apr 2008 15:20	Modified:	3 Apr 2008 8:57
Reporter:	dylan beukenkamp	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.0.51a	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:

--bootstrap is not available when using configure --disable-grant-options, so mysql_install_db failed.
/usr/local/mysql/bin/mysql_install_db: !: introuvable
Installing MySQL system tables...
080402 17:16:21 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--bootstrap'

Installation of system tables failed!

Examine the logs in /usr/local/mysql/var for more information.
You can try to start the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant &
and 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!

Removing the --bootstrap in : 
mysqld_install_cmd_line="$mysqld_bootstrap $defaults $mysqld_opt --bootstrap \

doesn't solve the problem :(

23a5a0dec3d09a206f4f9c00cd9f6d24

How to repeat:
./configure --disable-grant-options
make && make install
/usr/local/mysql/bin/mysql_install_db

23a5a0dec3d09a206f4f9c00cd9f6d24

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

According to http://dev.mysql.com/doc/refman/5.0/en/configure-options.html: "Run configure with the --disable-grant-options option to cause the the --bootstrap, --skip-grant-tables, and --init-file options for mysqld to be disabled. For Windows, the configure.js script recognizes the DISABLE_GRANT_OPTIONS flag, which has the same effect. The capability is available as of MySQL 5.0.34." So behavior is expected

But with these setting mysql_install_db don't work, i think that is a bug, you can't install the mysql server with this settings

According to http://dev.mysql.com/doc/refman/5.0/en/mysql-install-db.html:

"mysql_install_db needs to invoke mysqld with the --bootstrap  and --skip-grant-tables options (see Section 2.4.15.2, “Typical configure Options”). If MySQL was configured with the --disable-grant-options option, --bootstrap and --skip-grant-tables will be disabled. To handle this, set the MYSQLD_BOOTSTRAP environment variable to the full pathname of a server that has all options enabled. mysql_install_db will use that server."