Bug #44007 " bin/mysql_install_db --user=mysql" command running failed.
Submitted: 1 Apr 2009 7:33 Modified: 1 Apr 2009 8:09
Reporter: Venky P Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S1 (Critical)
Version:5.1.32 OS:Linux ((fedore 9)Linux devfed 2.6.25-14.fc9.x86_64 #1 SMP)
Assigned to: CPU Architecture:Any

[1 Apr 2009 7:33] Venky P
Description:
I am trying to compile mysql 5.1.32 with ssl option.

I am getting error when run "bin/mysql_install_db --user=mysql" this command.

Error message like:

Installing MySQL system tables...
090403  6:17:24 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-federated'
090403  6:17:24 [ERROR] Aborting

090403  6:17:24 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

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:

    shell> /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 are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!

How to repeat:
1. groupadd mysql
2. useradd -g mysql mysql
3.  gunzip < mysql-5.1.32.tar.gz | tar -xvf -
4. cd mysql-5.1.32
5. ./configure  --prefix=/usr/local/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-ssl=/usr/lib64/openssl
6. make
7. make install
8. cp support-files/my-medium.cnf /etc/my.cnf
9. cd /usr/local/mysql
10. chown -R mysql .
11. chgrp -R mysql .
12. bin/mysql_install_db --user=mysql

Suggested fix:
I observed mysql.sock file not created.
[1 Apr 2009 7:39] Sveta Smirnova
Thank you for the report.

Please check if you have configuration file in one of default locations with option '--skip-federated' set in.
[1 Apr 2009 8:09] Venky P
Thank u Sveta Smirnova. Now it is working.