mysql编译安装后不能启动

daoke

偶按照这个步骤装 mysql-3.23.58.tar.gz

tar zxvf mysql-3.23.58.tar.gz
cd mysql-3.23.58

./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql

make

make install

#prefix=/usr/local/mysql mysql安装的目标目录

#sysconfdir=/etc my.ini配置文件的路径

#localstatedir=/var/lib/mysql 数据库存放的路径

安装完以后要初始化数据库，当然你是升级的话不用做这步；

/usr/local/mysql/bin/mysql_install_db


如果系统没有mysql这个用户的话，最好做以下这步：

useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u 27 mysql

然后我启动mysql

/usr/local/mysql/bin/safe_mysqld &

ok，先看看mysql能否正常工作

mysql -uroot mysql

结果执行最后一个步骤的时候提示

[root@rh73 var]# mysql -uroot mysql
bash: mysql: command not found

EdwardRF

of course you are not going to get it as the mysql binary is not in the searching path.
you can either add a symbolic link to mysql binary or put the directory where mysql is installed in the path variable.

daoke

老兄，能不能说具体点啊。

EdwardRF

log in as root,
run last command as:
  /usr/local/mysql/bin/mysql -uroot mysql

if you want to create symbolic link into /usr/local/bin do:
ln -s /usr/local/mysql/bin/mysql /usr/local/bin/

if you want to add the path to just add a new script in /etc/profile.d/

daoke

3q very much

daoke

mysql -uroot -p 进入mysql成功。

cp support-files/mysql.server /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

用ntsysv设置使mysql每次启动都能自动运行。

好了，至此mysql安装完毕，你可以这样起动你的mysql服务

/etc/rc.d/init.d/mysqld start

运行最后一条后提示

[root@rh73 mysql-3.23.58]# /etc/rc.d/init.d/mysqld start
bash: /etc/rc.d/init.d/mysqld: /bin/sh: bad interpreter: Permission denied