【已解決】求救�。�！linux下編譯安裝mysql 數(shù)據(jù)庫的初始化mysql_install_db失敗

devilring

安裝步驟如下：
創(chuàng)建用戶
groupadd dba
useradd -g dba mysql
cp mysql-6.0.6-alpha.tar.gz /home/mysql/
chown -R mysql:dba /home/mysql/mysql-6.0.6-alpha.tar.gz

編譯安裝
su - mysql
tar zxvf /home/mysql/mysql-6.0.6-alpha.tar.gz
cd mysql-6.0.6-alpha

/configure \
--prefix=/home/mysql --with-extra-charsets=all  \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static \
--with-unix-socket-path=/home/mysql/tmp/mysql.sock \
 --with-charset=utf8 \
--with-collation=utf8_general_ci
--with-plugins=partition,heap,innobase,myisam,myisammrg,csv
make
make install

cd /home/mysql
su - root
cp share/mysql/my-medium.cnf /etc/my.cnf
chown -R mysql:dba /etc/my.cnf

建立配置文件
cd /home/mysql
su - root
cp share/mysql/my-medium.cnf /etc/my.cnf
chown -R mysql:dba /etc/my.cnf

修改配置文件 配置數(shù)據(jù)文件、日志的路徑
su - mysql
vi /etc/my.cnf
在[mysqld]段添加了以下代碼
User = mysql
basedir = /home/mysql
datadir = /home/mysql/data
socket = /home/mysql/tmp/mysql.sock
log-error = /home/mysql/log/alert.log
log_slow_queries = /home/mysql/log/slow.log

mkdir log data tmp

初始MySQL配置表（用戶表 權(quán)限表等）
./bin/mysql_install_db --basedir=/home/mysql/ --datadir=/home/mysql/data --force

到這步出錯(cuò)了，如下：

./bin/mysql_install_db --basedir=/home/mysql/ --datadir=/home/mysql/data --force
Installing MySQL system tables...

Installation of system tables failed!  Examine the logs in
/home/mysql/data for more information.

You can try to start the mysqld daemon with:

    shell> /home/mysql//libexec/mysqld --skip-grant &

and use the command line tool /home/mysql//bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /home/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 /home/mysql/data 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 /home/mysql//scripts/mysqlbug script!

cenalulu

/home/mysql/data 下應(yīng)該會(huì)有個(gè) hostname命名的 .err 文件，里面會(huì)有詳細(xì)報(bào)錯(cuò)

devilring

data下沒有，不過我在自己定義的log目錄里看到/home/mysql/log/alert.log,里面顯示的錯(cuò)誤如下：
120702 12:46:52 [ERROR] /home/mysql/libexec/mysqld: unknown option '--skip-federated'
120702 12:46:52 [ERROR] Aborting

120702 12:46:52 [Note] /home/mysql/libexec/mysqld: Shutdown complete

可是msqld是binary文件，我怎么改��？？

cenalulu

嗯，就是這個(gè)報(bào)錯(cuò)，提示 --skip-fedrated 配置無法識(shí)別， 把 my.cnf 中的這行注釋掉即可

devilring

搞定了，謝謝