mysql的問題 - BBS
By Barb Cronin
at 2005-03-08T11:49
at 2005-03-08T11:49
Table of Contents
我用原本是想要利用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!
請問我該怎麼辦呢?
謝謝!
--
Tags:
BBS
All Comments
Related Posts
awstats對於utf8的search string的亂봠…
By Vanessa
at 2005-03-08T01:12
at 2005-03-08T01:12
cvsup之後, make search 會發生錯誤
By Harry
at 2005-03-07T21:57
at 2005-03-07T21:57
Re: dmesg 出現的錯誤訊息
By Edwina
at 2005-03-07T13:48
at 2005-03-07T13:48
apache啟動後看不到網頁,該怎麼做?
By Quintina
at 2005-03-07T08:25
at 2005-03-07T08:25
Re: 下什麼指令可以查FREE_BSD的版本呢?
By Linda
at 2005-03-06T17:24
at 2005-03-06T17:24