entityMap|blocks|key|7374b|text|这并不是真的不安全。您有几个选择。首先，私有网络上的服务器是否在防火墙后面？或者它们只能通过公共ip地址相互连接？如果前者是真的，那你就没问题。但是，我会在服务器上添加防火墙规则，以便它只允许来自另一台计算机的连接。如果它们是在公共IP地址上连接，则需要执行相同的操作，并为MySQL使用非标准端口。您还可以添加另一个NIC并将MySQL服务绑定到该NIC。这样，如果黑客发现您的服务器，它将显示为关闭了所有端口。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6m9gs^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|D|9|@]|A|@]|B|$]]|$2|C|4|-4|6|7|8|E|9|@]|A|@]|B|$]]]]

It's not really insecure. You have a couple of options. First, are the servers on a private network behind a firewall? Or are they only able to connect with each other over public ip address? If the former is true, you are fine. I would however add firewall rules on the server so that it only allows connections from the other machine. If they are connecting on public IP addresses, you'll need to do the same and also use a non-standard port for MySQL. You can also add another NIC and bind the MySQL service to that. This way if hackers discover your server, it will appear to have all ports closed.

entityMap|blocks|key|bfnmv|text|如果它是一个托管的数据库服务器，并且您有受保护的端点URL+(意思是https://+host)，那么只需使用它作为主机名host:+'hostname'，这应该就足够了。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|dv4cc|如果它是您拥有的私有服务器，并且您拥有SSL证书，那么您可以使用以下内容：|975cb|const+fs+=+require('fs');
const+mysql+=+require('mysql');

var+connection+=+mysql.createConnection({
++++host:+'127.0.0.1',
++++port:+'3306',
++++user:+'root',
++++password:+'passw0rd',
++++database:+'test',
++++ssl:+{
++++++++ca:+fs.readFileSync(__dirname+%2B+'/certs/ca.pem'),
++++++++key:+fs.readFileSync(__dirname+%2B+'/certs/client-key.pem'),
++++++++cert:+fs.readFileSync(__dirname+%2B+'/certs/client-cert.pem')
++++}
});

connection.connect();|code-block|syntax|javascript|a3qrh^0|1P|G|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|O|9|@$A|P|B|Q|C|D]]|E|@]|F|$]]|$2|G|4|H|6|7|8|R|9|@]|E|@]|F|$]]|$2|I|4|J|6|K|8|S|9|@]|E|@]|F|$L|M]]|$2|N|4|-4|6|7|8|T|9|@]|E|@]|F|$]]]]

If its a hosted database server and you have the secured endpoint URL (meaning https:// host) then just use that as the hostname <code>host: 'hostname'</code> and that should be enough.

If it's a private server that you own and you have the SSL certificates then you can use the following:

<pre><code>const fs = require('fs');
const mysql = require('mysql');

var connection = mysql.createConnection({
 host: '127.0.0.1',
 port: '3306',
 user: 'root',
 password: 'passw0rd',
 database: 'test',
 ssl: {
 ca: fs.readFileSync(__dirname + '/certs/ca.pem'),
 key: fs.readFileSync(__dirname + '/certs/client-key.pem'),
 cert: fs.readFileSync(__dirname + '/certs/client-cert.pem')
 }
});

connection.connect();
</code></pre>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://www.howtoforge.com/tutorial/how-to-enable-ssl-and-remote-connections-for-mysql-on-centos-7/|blocks|key|1477k|text|您可以使用SSL进行连接，方法如下：|unstyled|depth|inlineStyleRanges|entityRanges|51ith|const+fs+=+require('fs');
const+mysql+=+require('mysql');
const+connection+=+mysql.createConnection({
++host+++++:+'hostname',
++port+++++:+'portnum',
++user+++++:+'db_user',
++password+:+'db_user_password',
++database+:+'db_name',
++charset++:+'utf8mb4',
++ssl:+{
++++++ca:+fs.readFileSync(__dirname+%2B+'/certs/ca.pem'),
++++++key:+fs.readFileSync(__dirname+%2B+'/certs/client-key.pem'),
++++++cert:+fs.readFileSync(__dirname+%2B+'/certs/client-cert.pem')
++}
});|code-block|syntax|javascript|95cd1|您还必须在MySql服务器上启用SSL。有一些tutorials+online展示了如何执行此操作，但您需要根用户访问权限才能执行此操作。|offset|length|av5bc^0|0|0|N|9|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|S|G|@]|H|@]|6|$]]|$A|I|C|J|2|K|F|T|G|@]|H|@]|6|$L|M]]|$A|N|C|O|2|E|F|U|G|@]|H|@$P|V|Q|W|A|X]]|6|$]]|$A|R|C|-4|2|E|F|Y|G|@]|H|@]|6|$]]]]

You can connect using SSL using something like this:

<pre><code>const fs = require('fs');
const mysql = require('mysql');
const connection = mysql.createConnection({
 host : 'hostname',
 port : 'portnum',
 user : 'db_user',
 password : 'db_user_password',
 database : 'db_name',
 charset : 'utf8mb4',
 ssl: {
 ca: fs.readFileSync(__dirname + '/certs/ca.pem'),
 key: fs.readFileSync(__dirname + '/certs/client-key.pem'),
 cert: fs.readFileSync(__dirname + '/certs/client-cert.pem')
 }
});
</code></pre>

You must also enable SSL on the MySql server. There are some <a href="https://www.howtoforge.com/tutorial/how-to-enable-ssl-and-remote-connections-for-mysql-on-centos-7/" rel="nofollow noreferrer">tutorials</a> online showing how to, but you would need root access to do this.

I'm attempting to link my Discord bot with a MySQL database that is on another server. However, this example is apparently insecure:

<pre class="lang-js prettyprint-override"><code>const mysql = require('mysql');
const connection = mysql.createConnection({
 host : 'hostname',
 port : 'portnum',
 user : 'db_user',
 password : 'db_user_password',
 database : 'db_name',
 charset : 'utf8mb4'
});
</code></pre>

How would I go about establishing a (more) secure connection?

How to securely connect to MySQL database on another server?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

 我正在尝试将我的Discord机器人链接到另一台服务器上的MySQL数据库。然而，这个例子显然是不安全的： const mysql = require('mysql');const connection = mysql.createConnection({  host     : 'hostname',  port ...

问如何安全地连接到另一台服务器上的MySQL数据库？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何安全地连接到另一台服务器上的MySQL数据库？EN