mysql的問題 - BBS

※ 引述《jiing24 (jiing)》之銘言：
: 我用原本是想要利用ports來安裝phpBB
: 結果後來從phpBB的安裝選單上發現phpBB似乎不支援mysql 5.x（不過ports幫你安裝的mySQL卻是5.0.0 alpha）
: 於是我去ports中deinstall mysql5-server和deinstall mysql5-client了
: 後來又利用ports安裝了mysql41-server和client在FreeBSD 5.3上
: 但是現在
: 我的mysql好像一直沒辦法用
: freebsd# mysql
: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
: freebsd# su
: freebsd# su jiing
: freebsd [/]-jiing->mysql
: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
: 都有問題
: 我也試著去執行
: freebsd# /usr/local/libexec/mysqld
: 050308 11:42:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
: 050308 11:42:29 [ERROR] Do you already have another mysqld server running on port: 3306 ?
: 050308 11:42:29 [ERROR] Aborting
: 050308 11:42:29 [NOTE] /usr/local/libexec/mysqld: Shutdown complete
: 它說我好像有另一個mysql deamon正在跑，而且用3306這個port
: 於是我用
: mysqladmin -u root shutdown
: 試著去關掉mysql
: 結果是
: mysqladmin: connect to server at 'localhost' failed
: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
: Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
: 請問我該怎麼辦呢？
: 謝謝！

我又
killall mysqld
殺掉所有的mysqld
檢查一下
ps xa | grep mysqld
果然沒有了

再執行一次mysqld
freebsd [/]-jiing->/usr/local/libexec/mysqld
050308 12:58:52 [WARNING] Can't create test file /var/db/mysql/freebsd.lower-test
/usr/local/libexec/mysqld: Can't change dir to '/var/db/mysql/' (Errcode: 13)
050308 12:58:52 [ERROR] Aborting
050308 12:58:52 [NOTE] /usr/local/libexec/mysqld: Shutdown complete

還是不行

--