环境: 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
那位高人帮忙解答一下,怎么回事阿?
按照如下方法安装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
那位高人帮忙解答一下,怎么回事阿?