为什么mysql启动不了_为什么mysql启动不了？

你的位置:

问答吧

-> MySQL

-> 问题详情

为什么mysql启动不了？

我今天卸载了系统自带的mysql，重新安装，过程如下：

# userdel mysql

# groupadd mysql

# useradd -g mysql mysql

# cd /usr/local

# tar zxvf mysql-standard-4.1.18-pc-linux-gnu-i686.tar.gz

# mv mysql-standard-4.1.18-pc-linux-gnu-i686 mysql

# cd mysql

# scripts/mysql_install_db --user=mysql

Installing all prepared tables

Fill help tables

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:

./bin/mysqladmin -u root password 'new-password'

./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

See the manual for more instructions.

You can start the MySQL daemon with:

cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:

cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at https://order.mysql.com

# chown -R root  .

# chown -R mysql data

# chgrp -R mysql .

# bin/mysqld_safe --user=mysql &

[1] 2884

[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data

我查了一下网上的资料说要CP一个文件，做法：

# cd support-files/

# cp my-medium.cnf /etc/

# mv my-medium.cnf my.cnf

# bin/mysqld_safe --user=mysql &

[2] 3003

[root@localhost mysql]# A mysqld process already exists

[2]+  Exit 1                  bin/mysqld_safe --user=mysql

[root@localhost mysql]# service mysqld start

Timeout error occurred trying to start MySQL Daemon.

启动 MySQL：                                               [失败]

# vi mysql_stop.sh

!/bin/sh

/usr/local/mysql/bin/mysqladmin -uroot -p123456 shutdown

:wq

# chmod 755 mysql_stop.sh

# cp mysql_stop.sh /usr/sbin

cp：是否覆盖“/usr/sbin/mysql_stop.sh”? y

./bin/mysqld_safe &

[2] 3989

[root@localhost mysql]# A mysqld process already exists

我哪里做错了？该怎么办啊？

作者: 紫藤

发布时间: 2006-04-21

http://bbs.mysql.cn/thread-821-1-1.html

看看文章里的第五步你做了吗。

作者: shahaier

发布时间: 2006-04-21

谢谢你！～我还奇怪呢。这里怎么没有让用./configure 呢。

作者: 紫藤

发布时间: 2006-04-21

＃./configure --prefix=/usr/local/mysql --with-charset=gb2312

NOTE: This is a MySQL binary distribution. It's ready to run, you don't

need to configure it!

To help you a bit, I am now going to create the needed MySQL databases

and start the MySQL server for you.  If you run into any trouble, please

consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables

Fill help tables

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:

./bin/mysqladmin -u root password 'new-password'

./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

See the manual for more instructions.

You can start the MySQL daemon with:

cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:

cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at https://order.mysql.com

Starting the mysqld server.  You can test that it is up and running

with the command:

./bin/mysqladmin version

[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data

STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid

060421 10:15:20  mysqld ended

[root@localhost mysql]# chown -R mysql /usr/local/mysql

[root@localhost mysql]# ./configure --prefix=/usr/local/mysql --with-charset=gb2312

NOTE: This is a MySQL binary distribution. It's ready to run, you don't

need to configure it!

To help you a bit, I am now going to create the needed MySQL databases

and start the MySQL server for you.  If you run into any trouble, please

consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables

Fill help tables

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:

./bin/mysqladmin -u root password 'new-password'

./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run

the ./bin/mysql_fix_privilege_tables. Otherwise you will not be

able to use the new GRANT command!

You can start the MySQL daemon with:

cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:

cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at https://order.mysql.com

Starting the mysqld server.  You can test that it is up and running

with the command:

./bin/mysqladmin version

[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data

STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid

060421 10:15:58  mysqld ended

这是怎么回事啊？

作者: 紫藤

发布时间: 2006-04-21

你这样好吧，把你所有安装的都清楚掉，按照那个教程一步步的重新来做下，现在感觉你的东西好乱，没有什么头绪。

执行./configure --prefix=/usr/local/mysql --with-charset=gb2312的时候，看看你是否进入了相应的目录，还有C编译器可不可以用。

作者: shahaier

发布时间: 2006-04-21

可以请问一下怎么样清除掉我以前编译的那些嘛？

我今天早上把系统自带的删除了 # rpm -e --nodeps mysql-5.0.18-2.1

那我现在安装的是 mysql-standard-4.1.18-pc-linux-gnu-i686.tar.gz

我昨天安装过一次了，没有成功，我把解压后的mysql目录，用rm -rf 删除掉了

然后进行的今天的安装，这样做对嘛？我该怎么样改 呢？请你告诉我可以嘛？

这个mysql的安装折磨我快一个月了，我真的不知道该怎么办了？谢谢

作者: 紫藤

发布时间: 2006-04-21

我系统自带的mysql有这些？

# rpm -qa |grep -i mysql

MySQL-python-1.2.0-3.2.2

mysql-bench-5.0.18-2.1

mysql-connector-odbc-3.51.12-1.2.1

libdbi-dbd-mysql-0.8.1a-1.2.1

php-mysql-5.1.2-5

mysql-devel-5.0.18-2.1

perl-DBD-MySQL-3.0002-2.2.2

qt-MySQL-3.3.5-13

mysql-5.0.18-2.1

mysql-server-5.0.18-2.1

mod_auth_mysql-3.0.0-3

作者: 紫藤

发布时间: 2006-04-21

你下的是二进制包

建议不用这个。

http://download.mysql.cn/src/2006/0208/62.html

下这个源码包，再按照帖子上说的安装就可以了。

作者: yzcdf

发布时间: 2006-04-21

那我可以请问一下，我怎么样把我系统中现在存在的所有mysql包删除呢？

作者: 紫藤

发布时间: 2006-04-21

/usr/local/mysql

这个MYSQL的安装目录删除就可以，是mysql目录别删错了。把上级的删了就麻烦了。

作者: shahaier

发布时间: 2006-04-21

我知道了，，谢谢，非常感谢！～

作者: 紫藤

发布时间: 2006-04-21

要是删除了.怎么办??

作者: 肆无忌惮

发布时间: 2006-05-05