安装mysql 遇到的麻烦 求解答

来源:互联网 发布:淘宝薇薇家叶罗丽娃娃 编辑:程序博客网 时间:2024/05/13 04:10
环境: centos 5


按照如下方法安装mysql,

usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar zxvf mysql-5.1.29-rc.tar.gz
cd mysql-5.1.29-rc/
./configure --prefix=/usr/local/webserver/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-innodb
make && make install
chmod +w /usr/local/webserver/mysql
chown -R mysql:mysql /usr/local/webserver/mysql
cp support-files/my-medium.cnf /usr/local/webserver/mysql/my.cnf
cd ../

  ①、以mysql用户帐号的身份建立数据表:
/usr/local/webserver/mysql/bin/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/usr/local/webserver/mysql/data --user=mysql


   ②、启动MySQL
/bin/sh /usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/usr/local/webserver/mysql/my.cnf &


最近的一次是按照上面安装的,就最后一步的时候不行,启动不了,别的都没事




当我启动的时候提示:

[root@localhost /]# /usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/usr/local/webserver/mysql/my.cnf &   (只有这一行使我输入的,为什么下面又出来一个[root@localhost /]#)
[1] 15639
[root@localhost /]# 081126 23:36:12 mysqld_safe Logging to '/usr/local/webserver/mysql//data/localhost.localdomain.err'.
081126 23:36:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:36:13 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended

到这就不动了

查看进程和端口mysql根本就没有启动。


下面是:localhost.localdomain.err 的信息
[root@localhost ~]# cat /usr/local/webserver/mysql//data/localhost.localdomain.err
081126 23:14:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
081126 23:14:28  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
081126 23:14:29  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
081126 23:14:29  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
081126 23:14:30  InnoDB: Started; log sequence number 0 0
081126 23:14:30 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:14:30 [ERROR] Aborting

081126 23:14:30  InnoDB: Starting shutdown...
081126 23:14:31  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:14:31 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:14:31 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:16:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:16:04  InnoDB: Started; log sequence number 0 46409
081126 23:16:04 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:16:04 [ERROR] Aborting

081126 23:16:04  InnoDB: Starting shutdown...
081126 23:16:05  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:16:05 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:16:05 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:17:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:17:00  InnoDB: Started; log sequence number 0 46409
081126 23:17:00 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:17:00 [ERROR] Aborting

081126 23:17:00  InnoDB: Starting shutdown...
081126 23:17:02  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:17:02 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:17:02 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:20:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:20:18  InnoDB: Started; log sequence number 0 46409
081126 23:20:18 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:20:18 [ERROR] Aborting

081126 23:20:18  InnoDB: Starting shutdown...
081126 23:20:19  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:20:19 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:20:19 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:35:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:35:50  InnoDB: Started; log sequence number 0 46409
081126 23:35:50 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:35:50 [ERROR] Aborting

081126 23:35:50  InnoDB: Starting shutdown...
081126 23:35:52  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:35:52 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:35:52 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:36:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:36:12  InnoDB: Started; log sequence number 0 46409
081126 23:36:12 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:36:12 [ERROR] Aborting

081126 23:36:12  InnoDB: Starting shutdown...
081126 23:36:13  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:36:13 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:36:13 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:39:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:39:39  InnoDB: Started; log sequence number 0 46409
081126 23:39:39 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:39:39 [ERROR] Aborting

081126 23:39:39  InnoDB: Starting shutdown...
081126 23:39:41  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:39:41 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:39:41 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended
081126 23:48:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql//data
081126 23:48:04  InnoDB: Started; log sequence number 0 46409
081126 23:48:04 [ERROR] /usr/local/webserver/mysql//libexec/mysqld: unknown option '--skip-federated'
081126 23:48:04 [ERROR] Aborting

081126 23:48:04  InnoDB: Starting shutdown...
081126 23:48:06  InnoDB: Shutdown completed; log sequence number 0 46409
081126 23:48:06 [Note] /usr/local/webserver/mysql//libexec/mysqld: Shutdown complete

081126 23:48:06 mysqld_safe mysqld from pid file /usr/local/webserver/mysql//data/localhost.localdomain.pid ended




那位高人帮忙解答一下,怎么回事阿?

原创粉丝点击