| Bug #44909 | mysql_install_db reports "unkonwn option --skip-federated" | ||
|---|---|---|---|
| Submitted: | 15 May 2009 19:46 | Modified: | 16 May 2009 16:17 |
| Reporter: | devesh gade | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 5.1.34 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[15 May 2009 19:49]
devesh gade
config.log file has been attached
Attachment: add.ldif~ (application/octet-stream, text), 206 bytes.
[16 May 2009 16:17]
MySQL Verification Team
Thank you for the bug report. You probably has an my.cnf file option in the path like showed below in Ubuntu 8.10 running in VirtualBox: miguel@txg:~/mysql-5.1.34-linux-i686-glibc23$ scripts/mysql_install_db --basedir=/home/miguel/mysql-5.1.34-linux-i686-glibc23/ --datadir=/home/miguel/mysql-5.1.34-linux-i686-glibc23/data/ Installing MySQL system tables... 090516 12:43:07 [ERROR] /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysqld: unknown option '--skip-bdb' 090516 12:43:07 [ERROR] Aborting 090516 12:43:07 [Warning] Forcing shutdown of 2 plugins 090516 12:43:07 [Note] /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysqld: Shutdown complete <cut> miguel@txg:~/mysql-5.1.34-linux-i686-glibc23$ ls /etc/mysql/my.cnf -la -rw-r--r-- 1 root root 4227 2008-09-19 10:24 /etc/mysql/my.cnf <cut> removing my.cnf from the path: miguel@txg:~/mysql-5.1.34-linux-i686-glibc23$ scripts/mysql_install_db --basedir=/home/miguel/mysql-5.1.34-linux-i686-glibc23/ --datadir=/home/miguel/mysql-5.1.34-linux-i686-glibc23/data/ Installing MySQL system tables... 090516 13:09:07 [Warning] Forcing shutdown of 2 plugins OK Filling help tables... 090516 13:09:08 [Warning] Forcing shutdown of 2 plugins OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysqladmin -u root password 'new-password' /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysqladmin -u root -h txg password 'new-password' Alternatively you can run: /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. miguel@txg:~/mysql-5.1.34-linux-i686-glibc23$ scripts/mysql_install_db --basedir=/home/miguel/mysql-5.1.34-linux-i686-glibc23/ --datadir=/home/miguel/mysql-5.1.34-linux-i686-glibc23/data/ Installing MySQL system tables... 090516 13:09:07 [Warning] Forcing shutdown of 2 plugins OK Filling help tables... 090516 13:09:08 [Warning] Forcing shutdown of 2 plugins OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysqladmin -u root password 'new-password' /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysqladmin -u root -h txg password 'new-password' Alternatively you can run: /home/miguel/mysql-5.1.34-linux-i686-glibc23//bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.
Description: During the installation process followed by me on the MySQL website,the "mysql_install_db" command does not run.I have attached the output of the comman d line as well as the config.log file in the mysql-5.1.34 folder.Awaiting yuor reply. The detailed output of the command is: [root@localhost mysql]# bin/mysql_install_db --user=mysql Installing MySQL system tables... 090516 0:54:49 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-federated' 090516 0:54:49 [ERROR] Aborting 090516 0:54:49 [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: i have no idea what to type here