从本地机器连接到MySQL在AWS [英] Connect to MySQL on AWS from local machine

问题描述

我想建立一个访问MySQL数据库在AWS上我的本地机器一个开发环境，但我不断收到一个无法连接的消息。

I am trying to set up a dev environment on my local machine that accesses a MySQL DB on AWS, but I keep getting a "Can't connect" message.

mysql_connect('xxx.xxx.xxx.xxx:3306', 'USERNAME', 'PASSWORD');

我也注释掉绑定地址在my.cnf文件，并授予权限所连接的IP地址。

I also commented out the bind-address in the my.cnf file, and granted permissions to the IP address that is connecting.

有谁成功地得到这个工作？

Anyone ever successfully get this working?

推荐答案

我想这是亚马逊的防火墙，请尝试使用SSH隧道：

I suppose this is firewalled by Amazon, try using a SSH tunnel:

<一个href="http://blogs.oracle.com/divyen/entry/connecting_mysql_server_on_amazon">http://blogs.oracle.com/divyen/entry/connecting_mysql_server_on_amazon

注：使用IP过滤即使是在不打开MySQL的公共互联网。 SSH隧道是方式更安全。它的最好的部分：隧道可能是与本地主机访问：3306你的机器上，无需更改配置：）

Note: Do not open MySQL to the public internet, not even when using IP filtering. SSH tunnels are way more secure. Best part of it: The tunnel could be accessible with localhost:3306 on your machine, no need to change the config : )

这篇关于从本地机器连接到MySQL在AWS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！