econnrefused MySQL_node.js mysql错误：ECONNREFUSED

最新推荐文章于 2024-08-01 09:37:44 发布

朝阳萌熊

最新推荐文章于 2024-08-01 09:37:44 发布

阅读量710

点赞数

文章标签： econnrefused MySQL

本文链接：https://blog.csdn.net/weixin_42382944/article/details/113895090

版权

为什么我无法连接到mysql服务器？

在同一台服务器上，Apache / PHP服务器正在运行，并且连接正常！

var mysql_link = {

host : 'localhost',

port : 3308,

database: 'nodetest',

user : 'root',

password : 'xxx'

};

var connection = mysql.createConnection(mysql_link);

connection.connect(function(err){

console.log(err);

if(err != null){

response.write('Error connecting to mysql:' + err+'\n');

}

});

connection.end();

错误

{ [Error: connect ECONNREFUSED]

code: 'ECONNREFUSED',

errno: 'ECONNREFUSED',

syscall: 'connect',

fatal: true }

更新

root@dyntest-amd-6000-8gb /var/www/node/dyntest # ps ax | grep mysqld

7928 pts/0 S+ 0:00 grep mysqld

28942 ? S 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid

29800 ? Sl 17:31 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/lib/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306