如何使用带有3306端口的XDevAPI连接器将mysql连接到节点js [英] How to connect mysql to node js using XDevAPI connector with 3306 port

问题描述

我安装了XDevAPI来连接mysql和nodejs.但是它抛出诸如服务器消失了"之类的错误，因为我使用的是3306端口.该如何解决.

I installed XDevAPI for connecting mysql and nodejs. but it throw error like "The server gone away" because i am using 3306 port. how to solve this.

推荐答案

端口3306默认为经典的MySQL Wire Protocol.用于Node.js的MySQL X DevAPI Connector仅支持X协议，该协议由X插件实现(默认在端口33060上实现).

Port 3306 defaults to the classic MySQL Wire Protocol. The MySQL X DevAPI Connector for Node.js only supports the X Protocol, which is implemented by the X Plugin (by default on port 33060).

您可以通过更新mysqlx_port服务器变量或在启动服务器时使用--mysqlx-port=选项来更改此设置.如果要在端口3306上使用X协议，则在启动服务器时还必须更新port变量或使用--port=选项使用其他值.

You can change this by updating the mysqlx_port server variable or using the --mysqlx-port= option when starting the server. If you want to use the X Protocol on port 3306 though you will also have to update the port variable or use a different value with the --port= option when starting the server.

免责声明:我是MySQL X DevAPI Connector for Node.js的首席开发人员

Disclaimer: I'm the lead developer of the MySQL X DevAPI Connector for Node.js

这篇关于如何使用带有3306端口的XDevAPI连接器将mysql连接到节点js的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！