ubuntu上安裝mysql后mysql.server不能啟動(dòng)問(wèn)題的解決
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基本安裝完畢,然后就要啟動(dòng)mysql了.
先試試mysqld_safe可以不:
1.bin/mysqld_safe &
2.ps -ef | grep mysql
可以查到mysql的進(jìn)程,ok,kill掉mysql的進(jìn)程
現(xiàn)在試試以服務(wù)的方式啟動(dòng)mysql:
1./etc/init.d/mysql.server
報(bào)錯(cuò)了:Starting MySQL../etc/init.d/mysql: line 159: kill: (6638) - No such process
于是sudo vi /etc/init.d/mysql.server,查找到啟動(dòng)mysql的腳本,在大約307行左右.把變量打印出來(lái).
然后手工執(zhí)行啟動(dòng)mysql的命令:bin/mysqld_safe --datadir=/usr/local/mysql/var/ --pid-file=/usr/local/mysql/var/mysql.pid
發(fā)現(xiàn)啟動(dòng)mysql錯(cuò)誤,報(bào)permission deny.于是懷疑是用戶權(quán)限問(wèn)題導(dǎo)致/usr/mysql/var/mysql.pid文件無(wú)法創(chuàng)建.
再重新執(zhí)行上面的命令:sudo bin/mysqld_safe --datadir=/usr/local/mysql/var/ --pid-file=/usr/local/mysql/var/mysql.pid
至此真相大白!在手工執(zhí)行/etc/init.d/mysql.server時(shí),也要記得"sudo".
posted on 2008-04-18 11:57 pony 閱讀(5644) 評(píng)論(0) 編輯 收藏 所屬分類: linux