防火墙阻塞mySQL端口

Question

我试图通过node.js程序连接到mysql，但是它引发了一个错误。

我无法通过端口3306连接到mysql。我已经在我的电脑上安装了apache。

我试过http://www.cyberciti.biz/tips/linux-iptables-18-allow-mysql-server-incoming-request.html，但它仍然不起作用。

错误：

Error: connect ECONNREFUSED
    at errnoException (net.js:901:11)
    at Object.afterConnect [as oncomplete] (net.js:892:19)
    --------------------
    at Handshake.Sequence (/opt/lampp/htdocs/1nodeapp/node_modules/mysql/lib/protocol/sequences/Sequence.js:15:20)
    at new Handshake (/opt/lampp/htdocs/1nodeapp/node_modules/mysql/lib/protocol/sequences/Handshake.js:9:12)
    at Protocol.handshake (/opt/lampp/htdocs/1nodeapp/node_modules/mysql/lib/protocol/Protocol.js:42:50)
    at Connection.connect (/opt/lampp/htdocs/1nodeapp/node_modules/mysql/lib/Connection.js:72:18)
    at Connection._implyConnect (/opt/lampp/htdocs/1nodeapp/node_modules/mysql/lib/Connection.js:182:10)
    at Connection.query (/opt/lampp/htdocs/1nodeapp/node_modules/mysql/lib/Connection.js:97:8)
    at Server.<anonymous> (/opt/lampp/htdocs/1nodeapp/mysql.js:22:18)
    at Server.EventEmitter.emit (events.js:98:17)
    at HTTPParser.parser.onIncoming (http.js:2108:12)
    at HTTPParser.parserOnHeadersComplete [as onHeadersComplete] (http.js:121:23)

Answer 1

概括上述各点：

( 1)尝试使用标准mysql客户端连接2)如果有效，请查找它正在使用的端口

netstat -nlp \ grep -i mysql

以便您可以配置适当的防火墙端口。

3)如果不起作用，就跑

ps -ef \ grep -i mysql grep grep -v grep

要了解mysql是否实际正在运行，如果没有(如这里所示)，启动它，并在连接仍然失败时重复。