centos安装mysql最后一步不行了。。

[xieyueqing]

我用xshell连到centos服务器上安装mysql，最后要启动服务的时候，执行 /usr/local/mysql/bin/mysqld_safe --user=root 显示两行之后不动了，没法往下走了。。

-bash-3.2# /usr/local/mysql/bin/mysqld_safe --user=root
120925 20:22:04 mysqld_safe Logging to '/usr/local/mysql/var/localhost.localdomain.err'.
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

然后我开另一个窗口，执行下面脚本，就报错：

-bash-3.2# /usr/local/mysql/share/mysql/mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]

这如何解决？ 非常感谢！

[Rotel-刘志东]

源代码安装、rpm包安装还是比较简单的。

[xieyueqing]

用 mysql-5.1.56.tar.gz 安装的。

[xieyueqing]

[Quote=引用 1 楼 的回复:]
看看报什么错误/usr/local/mysql/var/localhost.localdomain.err


另外用rpm包安装很简单的
[/Quote]
内容：
120925 20:05:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120925 20:05:32 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120925 20:05:32 [Note] Event Scheduler: Loaded 0 events
120925 20:05:32 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.56-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
120925 20:14:56 mysqld_safe A mysqld process already exists
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120925 20:22:04 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120925 20:22:04 [Note] Event Scheduler: Loaded 0 events
120925 20:22:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.56-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution

[xieyueqing]

顶起来~

[kejzhao]

不知道你的安装步骤是怎样的，估计是你安装的脚本有问题，
将我安装成功的步骤贴给你，你试试看


# ll
total 28652
-rw-r--r-- 1 root root 5517977 Aug 7 12:01 cmake-2.8.6.tar.gz
-rw-r--r-- 1 root root 23774015 Aug 7 12:02 mysql-5.5.22.tar.gz


mysql的安装
A.建立mysql用户以及mysql组
# groupadd mysql
# useradd -g mysql mysql
B.创建mysql数据库的相关目录，并且赋予权限
# mkdir -r /database/mysql
# mkdir /data/mysql -p
# mkdir /etc/mysql

# chown mysql.mysql /database/mysql
# chown mysql.mysql /etc/mysql
# chown mysql.mysql /data/mysql
# chmod 755 /data/mysql -R
# chmod 755 /etc/mysql
# chmod 755 /database/mysql

#cmake -DCMAKE_INSTALL_PREFIX=/database/mysql \
-DMYSQL_DATADIR=/data/mysql/ \
-DSYSCONFDIR=/database/mysql/ \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/etc/mysql/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_USER=mysql


我上面的版本较高，你的版本应该不用安装cmake，直接make 就可以

[xieyueqing]

[Quote=引用 6 楼 的回复:]
不知道你的安装步骤是怎样的，估计是你安装的脚本有问题，
将我安装成功的步骤贴给你，你试试看


# ll
total 28652
-rw-r--r-- 1 root root 5517977 Aug 7 12:01 cmake-2.8.6.tar.gz
-rw-r--r-- 1 root root 23774015 Aug 7 12:02 mysql-5.5.22.tar.gz

……
[/Quote]
我也是按网上的文章走的，一步一步走下来，结果最后两步了，不行了。。

[xieyueqing]

我在A窗口执行 /usr/local/mysql/bin/mysqld_safe --user=root 显示两行之后不动了，没法往下走了。。

-bash-3.2# /usr/local/mysql/bin/mysqld_safe --user=root
120925 20:22:04 mysqld_safe Logging to '/usr/local/mysql/var/localhost.localdomain.err'.
120925 20:22:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

这时候，我再打开一个xshell窗口B连上去，执行/usr/local/mysql/bin/mysql -u root -p 可以连进mysql，可以正常使用。

如果在A窗口用Ctrl+Z终止 /usr/local/mysql/bin/mysqld_safe --user=root 进程，B窗口就用不了mysql了， 执行/usr/local/mysql/bin/mysql -u root -p 会提示找不到 /tmp/mysql.sock 。

[iihero_]

以后台方式启起来：
/usr/local/mysql/bin/mysqld_safe& --user=root

不然, ctrl + z会把这个进程杀死。
你的mysql实际上已经正常启起来了。

[ACMAIN_CHM]

[Quote]120925 20:22:04 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120925 20:22:04 [Note] Event Scheduler: Loaded 0 events
120925 20:22:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.56-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution[/Quote]

你的MYSQL已经正常启动了？建议你尝试连接一下。

[rucypli]

看看报什么错误/usr/local/mysql/var/localhost.localdomain.err


另外用rpm包安装很简单的

[WWWWA]

A mysqld process already exists
120925 20:22:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

检查进程中MYSQLD是否在运行，连接试试

[xieyueqing]

谢谢各位！