mariadb run failed on Centos 6.4
my server installed centos 6.4(32bit) i'll source compile maria db 5.1.67/5.5.34 and yum install. but, i looking error message mysql_install_db. how fixed? :-(
maria source version : 5.1.67/5.1.62 5.5.34
compile option
[root@localhost var]# ./configure --prefix=/usr/local/mysql --with-extra-charsets=all --with-readline
mysql_install_db command
[root@localhost ]# /usr/local/mysql/bin/mysql_install_db
Installing MariaDB/MySQL system tables...
131209 11:07:26 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch)
131209 11:07:26 [ERROR] Aborting
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 --general-log gives you a log in /usr/local/mysql/var that may be helpful.
The latest information about mysql_install_db is available at http://kb.askmonty.org/v/installing-system-tables-mysql_install_db. MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria
Please check all of the above before mailing us! And remember, if you do mail us, you should use the /usr/local/mysql/bin/mysqlbug script!
[root@localhost ]# /usr/local/mysql/libexec/mysqld --skip-grant &
[1] 1402
[root@localhost ]# 131209 11:20:11 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:20:11 [ERROR] Aborting
[1]+ Exit 1 /usr/local/mysql/libexec/mysqld --skip-grant [root@localhost ]# cat /usr/local/mysql/var/localhost.localdomain.err 131209 11:08:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 131209 11:08:40 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:08:40 [ERROR] Aborting
131209 11:08:40 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended [root@localhost ]#
Answer
Just to clarify the above answer, there was an error in the my.cnf config file. When this was fixed, the error went away.