我用原本是想要利用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!
請問我該怎麼辦呢?
謝謝!
--
結果後來從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!
請問我該怎麼辦呢?
謝謝!
--
All Comments