blocks|key|132377|text|到目前为止，"PubliclyAccessible“变量在Cloudformation工具中不可用。因此，如果您使用CloudFormation模板部署RDS，则没有更改此参数的选择。默认情况下是"No“。但如果您使用的是AWS控制台，您可以选择将"Publicly“值从默认的No更改为Yes。我认为AWS应该用这个参数更新cloudformation+"AWS::RDS::DBInstance“函数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|132378|谢谢。|132379|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

As of now "PubliclyAccessible" variable is not available in the Cloudformation tool. So if you are deploying your RDS using CloudFormation template, you have no choice of changing this parameter. Its by default "No". But if you are using AWS console, you have choice of changing "Publicly Accessible" value to Yes from default No. I think AWS should update the cloudformation "AWS::RDS::DBInstance" function with this parameter.

Thanks.

blocks|key|132405|text|我在寻找同样的答案时偶然发现了这一点。可悲的是，10个月后，答案似乎仍然是“不”--你不能将现有的数据库更改为公开可用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|132406|但是-你可以靠近...即使不能公开使用，也可以在同一个私有网络中启动EC2实例。您可以通过EC2实例设置从您的计算机到该数据库的SSH隧道-有效地提供对该实例的访问，而不必从快照重新启动它。|132407|您没有指定您的计算机的操作系统，所以我很方便地假设linux...|132408|首先，启动一个EC2实例，通过安全组授予它对您的RDS实例的访问权限，确保您可以登录到该EC2实例，并确保您可以从该EC2实例访问RDS+DB。如果其中任何一个失败了，剩下的都不会起作用。|132409|接下来，设置一个隧道：|132410|ssh+-v+-N+-L+1234:rds.endpoint:3306+yourec2username@your.ec2.host|code-block|syntax|javascript|132411|其中rds.endpoint是RDS实例的URL，.ec2.host是EC2实例的主机名，yourec2username是您在EC2主机上的用户名。|132412|然后，您可以使用以下命令连接到RDS实例|132413|mysql+-p+-u+dbuser+-h+127.0.0.1+-P+1234+dbname+--password=dbpassword|132414|希望这能帮助下一个偶然发现这个的人...|132415|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|L|7|16|8|@]|9|@]|A|$M|N]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

I stumbled across this looking for the same answer. Sadly it looks like 10 months later the answer is still "no" - you can't change an existing DB to be publicly available.

However - you can come close... Even though it isn't publicly available, it is available to EC2 instances you launch in that same VPC. And you can set up a SSH tunnel from your computer through an EC2 instance to that DB - effectively giving you access to the instance without having to relaunch it from a snapshot.

You didn't specify your computer's OS, so I'm conveniently going to assume linux...

First, launch an EC2 instance, give it access to your RDS instance via security groups, make sure you can log in to that EC2 instance, and make sure you can access the RDS DB from that EC2 instance. If any of that fails, the rest of this won't work.

Next, setup a tunnel:

<pre><code>ssh -v -N -L 1234:rds.endpoint:3306 yourec2username@your.ec2.host
</code></pre>

Where rds.endpoint is the URL for your RDS instance, your.ec2.host is the host name for your EC2 instance, and yourec2username is your username on the EC2 host.

You can then connect to the RDS instance with

<pre><code>mysql -p -u dbuser -h 127.0.0.1 -P 1234 dbname --password=dbpassword
</code></pre>

Hope that helps the next person that stumbles across this...

blocks|key|132480|text|您可以在您的私有网络中创建ssh通道，或者使用iptables进行端口转发，但最好也是最简单的解决方案是创建一个PubliclyAccessible标志为true的读取副本，然后将副本提升为主。我建议始终使用RDS端点的CNAME，这样您就可以在DNS中更改CNAME，而无需接触您的应用程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|132481|制作快照并恢复它会给你的应用程序增加不必要的停机时间。|132482|看!|132483|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

You could create a ssh tunnel in your VPC, or make a port forwarding with iptables but, the best and the simplest solution is create a read replica with the PubliclyAccessible flag in true and then promote the replica to master.
I recommend always use a CNAME of the RDS endpoint, so you could change the CNAME in the DNS without touch your app.

Making a snapshot and restore it will add a unnecessary downtime in your app.

Look!

blocks|key|132507|text|看起来AWS现在允许更改accessibility属性。但是，数据库似乎被修改了，在这段时间内，最终可能会出现连接问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|132508|我还没有找到任何关于它的博客/新闻文章。然而，在我的帐户中，我能够做到这一点。|132509|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

It seems as AWS now allows to change the accessibility property. However the database seems to be modified and during this time eventually connectivity issues may occur.

I have not found any blog / news article about it. However in my account I am able to do it.

blocks|key|132543|text|这是一个古老的问题，但这可能会对某些人有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|132544|不需要删除和恢复数据库，只需在亚马逊网络服务控制台中打开数据库实例，点击Modify并查找Additional+connectivity+configuration，之后只有Publicly+accessible和Not+publicly+accessible两个选项。选择您的选项，等待几秒钟，将修改应用到您的实例，然后eureka，就完成了。|offset|length|style|CODE|132545|有关更多信息，请查看the+official+docs|132546|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html^0|0|10|6|19|11|2F|J|2Z|N|0|A|H|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]|$D|X|E|Y|F|G]|$D|Z|E|10|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|J|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

This is an old question but this maybe can help someone.
Is not need to delete and restore the database, just open the DB instance in the AWS console, click on <code>Modify</code> and look for <code>Additional connectivity configuration</code>, later there are only two options there <code>Publicly accessible</code> and <code>Not publicly accessible</code>. Select your option, wait a few seconds to the modification is applied to your instance and eureka, its done.
For more info check <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html" rel="nofollow noreferrer">the official docs</a>

When you create a new amazon rds instance, you are offered to choose true/false for the "publicly accessible" option,
Is there a way to change this for an existing instance?

How do I change the publicly accessible option for Amazon RDS?

私有网络

数据库

当你创建一个新的amazon rds实例时，你可以为"publicly“选项选择true/false，有没有办法改变现有的实例？

问如何更改Amazon RDS的公开访问选项？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何更改Amazon RDS的公开访问选项？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何更改Amazon RDS的公开访问选项？
EN