ubuntu上安装mysql后mysql.server不能启动问题的解决

sdccf

作者: ketto  出自: http://www.linuxdiyf.com
mysql安装步骤:
1.下载mysql-6.0.4-alpha.tar.gz
2.tar -zxvf mysql-6.0.4-alpha.tar.gz
3.cd mysql-6.0.4-alpha
4../configure --prefix=/usr/local/mysql
5.make
6.sudo make install
7.sudo cp supported-files/my-medium.cnf /etc/my.cnf
8.sudo cp supported-files/mysql.server /etc/init.d
9.sudo chmod a+x /etc/ini.d/mysql.server
10.cd /usr/local/mysql
11.bin/mysql_install_db --user=mysql
到这里,mysql基本安装完毕,然后就要启动mysql了.
先试试mysqld_safe可以不:
1.bin/mysqld_safe &
2.ps -ef | grep mysql
可以查到mysql的进程,ok,kill掉mysql的进程
现在试试以服务的方式启动mysql:
1./etc/init.d/mysql.server
报错了:Starting MySQL../etc/init.d/mysql: line 159: kill: (6638) - No such process
于是sudo vi /etc/init.d/mysql.server,查找到启动mysql的脚本,在大约307行左右.把变量打印出来.
然后手工执行启动mysql的命令:bin/mysqld_safe --datadir=/usr/local/mysql/var/ --pid-file=/usr/local/mysql/var/mysql.pid
发现启动mysql错误,报permission deny.于是怀疑是用户权限问题导致/usr/mysql/var/mysql.pid文件无法创建.
再重新执行上面的命令:sudo bin/mysqld_safe --datadir=/usr/local/mysql/var/ --pid-file=/usr/local/mysql/var/mysql.pid
至此真相大白!在手工执行/etc/init.d/mysql.server时,也要记得"sudo".

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/31/showart_570126.html