blocks|key|3111831|text|可能是因为您尚未将分配给EC2实例的Amazon+Security+Group配置为在端口3306+(MySQL的默认端口)上接受传入请求。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3111832|如果是这种情况，您只需单击几次按钮即可轻松打开安全组的端口：|3111833|1)登录您的亚马逊网络服务控制台，然后转到'EC2‘|3111834|2)在左侧菜单的'Network+&+Security‘下，转到'Security+Groups’|3111835|3)检查有问题的安全组|3111836|4)点击“Inbound”选项卡|3111837|5)从下拉列表中选择'MYSQL‘并点击'Add+Rule’|3111838|可能不是原因，但值得一试。|3111839|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.amazonwebservices.com/AWSEC2/latest/UserGuide/using-network-security.html^0|I|L|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|14|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|15|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|17|8|@]|9|@]|C|$]]|$1|N|3|O|5|6|7|18|8|@]|9|@]|C|$]]|$1|P|3|Q|5|6|7|19|8|@]|9|@]|C|$]]|$1|R|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|S|$T|$5|U|V|W|C|$X|Y]]]]

It could be that you have not configured the <a href="http://docs.amazonwebservices.com/AWSEC2/latest/UserGuide/using-network-security.html" rel="noreferrer">Amazon Security Group</a> assigned to your EC2 Instance to accept incoming requests on port 3306 (default port for MySQL).

If this is the case then you can easily open up the port for the security group in a few button clicks:

1) Log into you AWS Console and go to 'EC2'

2) On the left hand menu under 'Network &amp; Security' go to 'Security Groups'

3) Check the Security Group in question

4) Click on 'Inbound tab'

5) Choose 'MYSQL' from drop down list and click 'Add Rule'

Might not be the reason but worth a go...

blocks|key|2897720|text|可能存在以下原因之一：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2897721|2897722|您需要在亚马逊安全组中输入一个条目，才能允许从您的计算机远程访问亚马逊EC2实例。:-我相信这是由您完成的，因为从您的问题看，您似乎已经使用0.0.0.0创建了一个条目，它允许每个人访问该计算机。|ordered-list-item|2897723|+MySql不允许用户从远程计算机连接：-默认情况下，MySql创建具有管理员访问权限的根用户id。但是root+id的访问权限仅限于localhost。这意味着，如果您尝试从远程计算机访问MySql，则具有正确密码的根用户id将不起作用。要解决此问题，您需要允许根用户或其他数据库用户从远程计算机访问MySQL。我不建议允许root用户id从远程机器访问数据库。您可以使用通配符%25指定任何远程计算机。|2897724|检查计算机的本地防火墙是否未启用。如果已启用，请确保端口3306已打开。|2897725|2897726|请访问以下链接：How+Do+I+Enable+Remote+Access+To+MySQL+Database+Server?|offset|length|2897727|entityMap|0|LINK|mutability|MUTABLE|url|http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html^0|0|0|0|0|0|0|8|1J|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|10|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@$M|13|N|14|1|15]]|A|$]]|$1|O|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

There could be one of the following reasons:

<ol>
<li>You need make an entry in the Amazon Security Group to allow remote
access from your machine to Amazon EC2 instance. :- I believe this
is done by you as from your question it seems like you already made
an entry with 0.0.0.0, which allows everybody to access the machine.</li>
<li>MySQL not allowing user to connect from remote machine:- By
default MySql creates root user id with admin access. But root
id's access is limited to localhost only. This means that root user
id with correct password will not work if you try to access MySql
from a remote machine. To solve this problem, you need to
allow either the root user or some other DB user to access MySQL from remote
machine. I would not recommend allowing root user id accessing DB
from remote machine. You can use wildcard character % to specify any remote machine.</li>
<li>Check if machine's local firewall is not enabled. And if its enabled
then make sure that port 3306 is open.</li>
</ol>

Please go through following link: <a href="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html">How Do I Enable Remote Access To MySQL Database Server?</a>

blocks|key|234568|text|正如上面的响应中提到的，它可能与AWS安全组和其他事情有关。但是，如果您创建了一个用户并为其提供了远程访问'%25‘，但仍然收到此错误，请检查您的mysql配置文件，在debian上，您可以在以下位置找到它:+/etc/mysql/my.cnf并找到行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|234569|bind-address++++++++++++=+127.0.0.1|code-block|syntax|javascript|234570|并将其更改为：|234571|bind-address++++++++++++=+0.0.0.0|234572|然后重启mysql。|234573|在debian/ubuntu上：|234574|/etc/init.d/mysql+restart|234575|我希望这对你有用。|234576|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

as mentioned in the responses above, it could be related to AWS security groups, and other things. but if you created a user and gave it remote access '%' and still getting this error, check your mysql config file, on debian, you can find it here: /etc/mysql/my.cnf and find the line:

<pre><code>bind-address = 127.0.0.1
</code></pre>

and change it to:

<pre><code>bind-address = 0.0.0.0
</code></pre>

and restart mysql.

on debian/ubuntu:

<pre><code>/etc/init.d/mysql restart
</code></pre>

I hope this works for you.

blocks|key|235710|text|我知道这是个老帖子但是..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|235711|我正在经历这个问题，并且我已经确定我的问题实际上不是EC2实例。这似乎是MySQL客户端驱动程序软件中的一个错误。我还没有做彻底的研究，但我甚至在EC2实例上安装了MySQL工作台，它也不稳定-它间歇性地无法连接(错误是“连接已取消”)。This+link建议的是堆栈下部可能存在的bug，而不是EC2。|offset|length|235712|当然，我没有做详尽的研究，我的帖子可能实际上是错误的，但无论如何，值得注意和/或探索。|235713|entityMap|0|LINK|mutability|MUTABLE|url|http://bugs.mysql.com/bug.php?id=64003^0|0|3B|9|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

I know this is an old post but...

I'm experiencing this issue and I've established that my problem is in fact not the EC2 instance. It seems like it might be a bug in the MySQL client driver software. I haven't done thorough research yet but I went as far as to install MySQL Workbench on the EC2 instance and IT also is erratic - it intermittently fails to connect (error is "connection cancelled"). <a href="http://bugs.mysql.com/bug.php?id=64003" rel="nofollow">This link</a> suggests a possible bug lower down the stack, not EC2.

Of course, I have not done exhaustive research and my post might actually be off the mark, but worth noting and/or exploring anyway, IMHO.

blocks|key|3111920|text|对此的解决方案是三个步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3111921|更改绑定地址以接受来自所有主机的连接(0.0.0.0).|3111922|Within+(0.0.0.0).|unordered-list-item|3111923|
|3111924|Within控制台-+my.cnf特定的安全组打开您的MySQL端口(默认为3306)以接受来自所有主机的连接(0.0.0.0).|3111925|3111926|Within(0.0.0.0).|3111927|3111928|Within+my.cnf防火墙将mysql端口(默认为3306)添加到例外。|3111929|3111930|这将开始接受远程连接。|3111931|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|Z|8|@]|9|@]|A|$]]|$1|K|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|L|3|M|5|F|7|11|8|@]|9|@]|A|$]]|$1|N|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|13|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|15|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|U|$]]

Solution to this is three steps:

<ol>
<li>Within MySQL my.ini/ my.cnf file change the bind-address to accept connection from all hosts (0.0.0.0).</li>
<li>Within aws console - ec2 - specific security group open your mysql port (default is 3306) to accept connections from all hosts (0.0.0.0).</li>
<li>Within windows firewall add the mysql port (default is 3306) to exceptions. </li>
</ol>

And this will start accepting remote connections.

blocks|key|2897807|text|虽然这个问题似乎已经得到了回答，但您可以得到的另一个常见问题是DB用户配置错误。这是一个mysql管理和权限问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2897808|通过IP+10.55.142.100|offset|length|style|CODE|2897809|EC2_web启动的|unordered-list-item|2897810|EC2_DB通过同一安全组中的IP+10.55.142.144|ordered-list-item|2897811|EC2_DB和EC2_WEBare启动，可跨DB端口访问(3306)|2897812|EC2_DB具有可由DB根用户本地访问的mysql数据库('root'@'localhost')|2897813|EC2_DB+mysql+DB具有远程用户'my_user'@'%25'+IDENTIFIED+BY+PASSWORD+'password'+|2897814|从EC2_WEB对mysql的bash调用失败：mysql+-umy_user+-p+-h+ip-10-55-142-100.ec2.internal与主机对显式IP、公共DNS等的引用一样。|2897815|2897816|2897817|2897818|第6步失败，因为mysql+DB具有错误的用户权限。它需要这样：|2897819|GRANT+ALL+PRIVILEGES+ON+*.*+TO+'my_user'@'ip-10-55-142-144.ec2.internal'+IDENTIFIED+BY+PASSWORD+'password'|code-block|syntax|javascript|2897820|我认为%25可以在任何远程服务器上工作，但我发现事实并非如此。|2897821|如果这对你有帮助，请让我知道。|2897822|entityMap^0|0|5|D|0|0|I|D|0|0|T|I|0|L|1B|0|O|1F|0|0|0|0|0|0|3|1|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1F|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1G|8|@$D|1H|E|1I|F|G]]|9|@]|A|$]]|$1|N|3|O|5|M|7|1J|8|@]|9|@]|A|$]]|$1|P|3|Q|5|M|7|1K|8|@$D|1L|E|1M|F|G]]|9|@]|A|$]]|$1|R|3|S|5|M|7|1N|8|@$D|1O|E|1P|F|G]]|9|@]|A|$]]|$1|T|3|U|5|M|7|1Q|8|@$D|1R|E|1S|F|G]]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1W|8|@]|9|@]|A|$]]|$1|10|3|11|5|12|7|1X|8|@]|9|@]|A|$13|14]]|$1|15|3|16|5|6|7|1Y|8|@$D|1Z|E|20|F|G]]|9|@]|A|$]]|$1|17|3|18|5|6|7|21|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|22|8|@]|9|@]|A|$]]]|1A|$]]

Though this question seems to be answered, another common issue that you can get is the DB user has been mis-configured. This is a mysql administration and permissions issue:

<ol>
<li>EC2_DB launched with IP <code>10.55.142.100</code></li>
<li>EC2_web launched with IP <code>10.55.142.144</code></li>
<li>EC2_DB and EC2_WEBare in the same security group with access across your DB port (3306)</li>
<li>EC2_DB has a mysql DB that can be reached locally by the DB root user (<code>'root'@'localhost'</code>)</li>
<li>EC2_DB mysql DB has a remote user <code>'my_user'@'%' IDENTIFIED BY PASSWORD 'password'</code> </li>
<li>A bash call to mysql from EC2_WEB fails: <code>mysql -umy_user -p -h ip-10-55-142-100.ec2.internal</code> as does host references to the explicit IP, public DNS, etc.</li>
</ol>

<hr>

Step 6 fails because the mysql DB has the wrong user permisions. It needs this:

<pre><code>GRANT ALL PRIVILEGES ON *.* TO 'my_user'@'ip-10-55-142-144.ec2.internal' IDENTIFIED BY PASSWORD 'password'
</code></pre>

I would like to think that <code>%</code> would work for any remote server, but I did not find this to be the case.

Please let me know if this helps you.

blocks|key|237369|text|登录AWS管理控制台。导航到RDS，然后选择数据库实例，然后转到“安全组”。在安全组下添加CIDR/IP解决了此问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|237370|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Log into AWS Management Console. Navigate to RDS then select the db instance and go to "security Groups". Adding CIDR/IP under the security group fixed the problem.

blocks|key|231908|text|更改/etc/mysql/my.cnf|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|231909|bind-address++++++++++++=+127.0.0.1+to+0.0.0.0|code-block|syntax|javascript|231910|使用'%25‘host创建用户并重新启动：|231911|/etc/init.d/mysql+restart|231912|适合我！:)|231913|entityMap^0|2|H|0|0|5|4|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|10|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|R|$]]

Change <code>/etc/mysql/my.cnf</code>:

<pre><code>bind-address = 127.0.0.1 to 0.0.0.0
</code></pre>

Create user with '%' <code>host</code> and restart:

<pre><code>/etc/init.d/mysql restart
</code></pre>

Works for me! :)

blocks|key|234640|text|我检查了之前所有的答案(以及类似问题的答案)，但都没有成功，所以这里是最终对我起作用的方法。关键的一步是显式地将mysql服务器上的特权授予一个本地用户(对于服务器)，但是附加了我的本地IP+(myuser@*.*.*.*)。完整的分步解决方案如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|234641|234642|在服务器端的/etc/mysql/my.cnf中注释掉bind_address行(即EC2实例)。|ordered-list-item|234643|为EC2实例的安全组添加了一条用于MYSQL的规则(其他人也提到过)，端口为3306，源为My+IP或Anywhere。在对一个特定的数据库mydb使用有限权限的新用户steps.|234644|Create执行完所有命令后，两者都可以正常工作(基本上遵循此Amazon+tutorial中的说明)：|234645|234646|$EC2prompt>+mysql+-u根-p+...omitted输出...mysql>创建由‘your_strong_password’标识的用户'myuser'@'localhost‘；mysql>授予’mydb‘上的所有权限。*要执行此关键步骤，在尝试远程连接(ERROR+1130+(HY000):+Host+'*.*.*.23'+is+not+allowed+to+connect+to+this+MySQL+server)时，如果没有此步骤，我的本地地址将被拒绝：|234647|mysql>将'mydb'.*上的所有权限授予‘myuser’@‘*.23’；mysql>刷新权限；(replace‘..*.23’`根据您的本地IP地址)|234648|为了更好地解决这个问题，我退出了mysql到shell并重启了msyql服务器：|unordered-list-item|234649|234650|通过这些步骤，我能够愉快地从我的计算机连接到：|234651|$localprompt>+mysql+-h+myinstancename.amazonaws.com+-P+3306+-u+myuser+-p|234652|(用您的EC2实例的公共地址替换myinstancename.amazonaws.com+)|234653|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/hosting-wordpress.html^0|2P|E|0|0|6|H|R|C|0|19|5|1F|8|1Y|4|0|V|F|0|0|0|3Q|2C|0|1E|8|0|0|0|0|0|20|0|G|S|0^^$0|@$1|2|3|4|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|1J|8|@$9|1K|A|1L|B|C]|$9|1M|A|1N|B|C]|$9|1O|A|1P|B|C]]|D|@]|E|$]]|$1|L|3|M|5|I|7|1Q|8|@]|D|@$9|1R|A|1S|1|1T]]|E|$]]|$1|N|3|-4|5|6|7|1U|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1V|8|@$9|1W|A|1X|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1Y|8|@$9|1Z|A|20|B|C]]|D|@]|E|$]]|$1|S|3|T|5|U|7|21|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|22|8|@]|D|@]|E|$]]|$1|W|3|X|5|6|7|23|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|24|8|@$9|25|A|26|B|C]]|D|@]|E|$]]|$1|10|3|11|5|6|7|27|8|@$9|28|A|29|B|C]]|D|@]|E|$]]|$1|12|3|-4|5|6|7|2A|8|@]|D|@]|E|$]]]|13|$14|$5|15|16|17|E|$18|19]]]]

I went through all the previous answers (and answers to similar questions) without success, so here is what finally worked for me. The key step was to explicitly grant privileges on the mysql server to a local user (for the server), but with my local IP appended to it (<code>myuser@*.*.*.*</code>). The complete step by step solution is as follows:

<ol>
<li>Comment out the <code>bind_address</code> line in <code>/etc/mysql/my.cnf</code> at the server (i.e. the EC2 Instance). I suppose
<code>bind_address=0.0.0.0</code> would also work, but it's not needed as
others have mentioned.</li>
<li>Add a rule (as others have mentioned too) for MYSQL to the EC2 instance's security group with port 3306 and either <code>My IP</code> or <code>Anywhere</code> as Source. Both work fine after following all the steps.</li>
<li>Create a new user <code>myuser</code> with limited privileges to one particular
database <code>mydb</code> (basically following the instructions in this <a href="http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/hosting-wordpress.html" rel="nofollow">Amazon tutorial</a>):

<pre><code>$EC2prompt&gt; mysql -u root -p
[...omitted output...]
mysql&gt; CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'your_strong_password';
mysql&gt; GRANT ALL PRIVILEGES ON 'mydb'.* TO 'myuser'@'localhost';`
</code></pre></li>
<li>Here's the key step, without which my local address was refused when attempting a remote connection <code>(ERROR 1130 (HY000): Host '*.*.*.23' is not allowed to connect to this MySQL server)</code>:

<pre><code>mysql&gt; GRANT ALL PRIVILEGES ON 'mydb'.* TO 'myuser'@'*.*.*.23';
mysql&gt; FLUSH PRIVILEGES;`
</code></pre>

(replace <code>'*.*.*.23'</code> by your local IP address)</li>
<li>For good measure, I exited mysql to the shell and restarted the msyql server:

<code>$EC2prompt&gt; sudo service mysql restart</code></li>
<li>After these steps, I was able to happily connect from my computer with:

<code>$localprompt&gt; mysql -h myinstancename.amazonaws.com -P 3306 -u myuser -p</code>

(replace <code>myinstancename.amazonaws.com</code> by the public address of your EC2 instance)</li>
</ol>

blocks|key|231927|text|在创建像'myuser'@'+localhost‘这样的用户时，用户被限制为只能从localhost连接。创建一个仅用于远程访问的用户，并使用您将从其连接到MySQL服务器的远程客户端IP地址。如果您可以承担允许来自所有远程主机的连接的风险(通常在使用动态IP地址时)，则可以使用'myuser'@'%25‘。我这样做了，还从/etc/mysql/mysql.cnf+(Ubuntu)中删除了bind_address，现在它可以完美地连接了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|231928|mysql>+select+host,user+from+mysql.user;
%2B-----------%2B-----------%2B
%7C+host++++++%7C+user++++++%7C
%2B-----------%2B-----------%2B
%7C+%25+++++++++%7C+myuser++++%7C
%7C+localhost+%7C+mysql.sys+%7C
%7C+localhost+%7C+root++++++%7C
%2B-----------%2B-----------%2B
3+rows+in+set+(0.00+sec)|code-block|syntax|javascript|231929|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

While creating the user like 'myuser'@'localhost', the user gets limited to be connected only from localhost. Create a user only for remote access and use your remote client IP address from where you will be connecting to the MySQL server. If you can bear the risk of allowing connections from all remote hosts (usually when using dynamic IP address), you can use 'myuser'@'%'. I did this, and also removed bind_address from /etc/mysql/mysql.cnf (Ubuntu) and now it connects flawlessly.

<pre><code>mysql&gt; select host,user from mysql.user;
+-----------+-----------+
| host | user |
+-----------+-----------+
| % | myuser |
| localhost | mysql.sys |
| localhost | root |
+-----------+-----------+
3 rows in set (0.00 sec)
</code></pre>

blocks|key|3112067|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3112068|使用admin+user+|unordered-list-item|3112069|mysql+-u+admin-user+-p+(在PROMPT)|3112070|3112071|上输入密码)启动MYSQL|3112072|​|3112073|3112074|创建新用户：|3112075|创建由‘|3112076|’标识的用户‘|3112077|’@‘%25’；(%25+->+newuser|3112078|3112079|3112080|3112081|3112082|3112083|Grant权限：|3112084|将db_name.*上的SELECT、DELETE、INSERT、UPDATE授予'newuser'@'%25';|3112085|FLUSH+PRIVILEGES;|3112086|3112087|3112088|3112089|如果您正在运行EC2实例，请不要忘记使用MYSQL/Aurura添加安全组中的入站规则。|3112090|如果这些步骤不起作用，请检查/etc/mysql/my.cnf文件并将bind_address参数编辑为|3112091|3112092|+bind_address=0.0.0.0|blockquote|3112093|3112094|entityMap^0|0|1|1|0|0|0|0|1|1|2|2|1|0|0|0|0|1|1|1|0|0|0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|1I|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|1J|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|1K|7|@]|8|@]|9|$]]|$1|F|3|-4|4|5|6|1L|7|@]|8|@]|9|$]]|$1|G|3|H|4|5|6|1M|7|@]|8|@]|9|$]]|$1|I|3|J|4|5|6|1N|7|@]|8|@]|9|$]]|$1|K|3|-4|4|5|6|1O|7|@]|8|@]|9|$]]|$1|L|3|M|4|C|6|1P|7|@]|8|@]|9|$]]|$1|N|3|O|4|C|6|1Q|7|@]|8|@]|9|$]]|$1|P|3|Q|4|C|6|1R|7|@]|8|@]|9|$]]|$1|R|3|S|4|C|6|1S|7|@]|8|@]|9|$]]|$1|T|3|-4|4|5|6|1T|7|@]|8|@]|9|$]]|$1|U|3|-4|4|5|6|1U|7|@]|8|@]|9|$]]|$1|V|3|-4|4|5|6|1V|7|@]|8|@]|9|$]]|$1|W|3|J|4|5|6|1W|7|@]|8|@]|9|$]]|$1|X|3|-4|4|5|6|1X|7|@]|8|@]|9|$]]|$1|Y|3|Z|4|C|6|1Y|7|@]|8|@]|9|$]]|$1|10|3|11|4|C|6|1Z|7|@]|8|@]|9|$]]|$1|12|3|13|4|C|6|20|7|@]|8|@]|9|$]]|$1|14|3|-4|4|5|6|21|7|@]|8|@]|9|$]]|$1|15|3|-4|4|5|6|22|7|@]|8|@]|9|$]]|$1|16|3|J|4|5|6|23|7|@]|8|@]|9|$]]|$1|17|3|18|4|5|6|24|7|@]|8|@]|9|$]]|$1|19|3|1A|4|5|6|25|7|@]|8|@]|9|$]]|$1|1B|3|-4|4|5|6|26|7|@]|8|@]|9|$]]|$1|1C|3|1D|4|1E|6|27|7|@]|8|@]|9|$]]|$1|1F|3|-4|4|5|6|28|7|@]|8|@]|9|$]]|$1|1G|3|-4|4|5|6|29|7|@]|8|@]|9|$]]]|1H|$]]

<ul>
<li>START MYSQL using admin user

<ul>
<li>mysql -u admin-user -p (ENTER PASSWORD ON PROMPT)</li>
</ul></li>
<li>Create a new user:

<ul>
<li>CREATE USER 'newuser'@'%' IDENTIFIED BY 'password'; (% -> anyhost)</li>
</ul></li>
<li>Grant Privileges:

<ul>
<li>GRANT SELECT,DELETE,INSERT,UPDATE ON db_name.* TO 'newuser'@'%';</li>
<li>FLUSH PRIVILEGES;</li>
</ul></li>
</ul>

If you are running EC2 instance don't forget to add the inbound rules in security group with MYSQL/Aurura.

If these steps didn't work check /etc/mysql/my.cnf file and edit the 
bind_address param as 

<blockquote>
 bind_address=0.0.0.0
</blockquote>

blocks|key|235795|text|更新：+2017年2月|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|235796|235797|以下是用于远程访问MySQL的COMPLETE+STEPS+(部署在亚马逊EC2上)：-+|blockquote|235798|235799|1.在入站规则中添加MySQL。|235800|转到您的ec2实例的安全组，编辑入站规则并添加新规则，然后选择MySQL/Aurora+->+->+to+Anywhere。|CODE|235801|2.将绑定地址=+0.0.0.0添加到my.cnf|235802|在实例控制台：|235803|sudo+vi+/etc/mysql/my.cnf|code-block|syntax|javascript|235804|这将打开vi编辑器。|235805|在my.cnf文件中，在[mysqld]之后添加新行，并这样写：|235806|bind-address+=+0.0.0.0|235807|通过输入:wq(enter)保存文件|235808|现在重新启动MySQL：|235809|sudo+/etc/init.d/mysqld+restart|235810|3.创建远程用户并授予权限。|235811|登录到MySQL：|235812|mysql+-u+root+-p+mysql+(之后输入密码)|235813|现在编写以下命令：|235814|CREATE+USER+'jerry'@'localhost'+IDENTIFIED+BY+'jerrypassword';

CREATE+USER+'jerry'@'%25'+IDENTIFIED+BY+'jerrypassword';

GRANT+ALL+PRIVILEGES+ON+*.*+to+jerry@localhost+IDENTIFIED+BY+'jerrypassword'+WITH+GRANT+OPTION;

GRANT+ALL+PRIVILEGES+ON+*.*+to+jerry@'%25'+IDENTIFIED+BY+'jerrypassword'+WITH+GRANT+OPTION;

FLUSH+PRIVILEGES;

EXIT;|235815|在此之后，可以通过输入实例的公共dns/ip作为MySQL主机地址、用户名作为jerry和密码作为jerrypassword来远程访问MySQL+dB。(端口设置为默认端口3306)|235816|entityMap^0|0|3|0|0|F|E|0|0|0|V|C|1H|8|0|0|0|0|0|C|8|0|0|4|3|0|0|0|0|0|0|M|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1O|8|@$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|1S|8|@$9|1T|A|1U|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]|$1|K|3|L|5|6|7|1W|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|1X|8|@$9|1Y|A|1Z|B|O]|$9|20|A|21|B|O]]|D|@]|E|$]]|$1|P|3|Q|5|6|7|22|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|23|8|@]|D|@]|E|$]]|$1|T|3|U|5|V|7|24|8|@]|D|@]|E|$W|X]]|$1|Y|3|Z|5|6|7|25|8|@]|D|@]|E|$]]|$1|10|3|11|5|6|7|26|8|@$9|27|A|28|B|O]]|D|@]|E|$]]|$1|12|3|13|5|V|7|29|8|@]|D|@]|E|$W|X]]|$1|14|3|15|5|6|7|2A|8|@$9|2B|A|2C|B|O]]|D|@]|E|$]]|$1|16|3|17|5|6|7|2D|8|@]|D|@]|E|$]]|$1|18|3|19|5|V|7|2E|8|@]|D|@]|E|$W|X]]|$1|1A|3|1B|5|6|7|2F|8|@]|D|@]|E|$]]|$1|1C|3|1D|5|6|7|2G|8|@]|D|@]|E|$]]|$1|1E|3|1F|5|6|7|2H|8|@$9|2I|A|2J|B|O]]|D|@]|E|$]]|$1|1G|3|1H|5|6|7|2K|8|@]|D|@]|E|$]]|$1|1I|3|1J|5|V|7|2L|8|@]|D|@]|E|$W|X]]|$1|1K|3|1L|5|6|7|2M|8|@]|D|@]|E|$]]|$1|1M|3|-4|5|6|7|2N|8|@]|D|@]|E|$]]]|1N|$]]

<h2>Update: Feb 2017</h2>

<blockquote>
 Here are the COMPLETE STEPS for remote access of MySQL (deployed
 on Amazon EC2):- 
</blockquote>

<h2>1. Add MySQL to inbound rules.</h2>

Go to security group of your ec2 instance -> edit inbound rules -> add new rule -> choose <code>MySQL/Aurora</code> and source to <code>Anywhere</code>. 

<h2>2. Add bind-address = 0.0.0.0 to my.cnf</h2>

In instance console: 

<pre><code>sudo vi /etc/mysql/my.cnf
</code></pre>

this will open vi editor. 
in my.cnf file, after <code>[mysqld]</code> add new line and write this:

<pre><code>bind-address = 0.0.0.0
</code></pre>

Save file by entering <code>:wq</code>(enter)

now restart MySQL:

<pre><code>sudo /etc/init.d/mysqld restart
</code></pre>

<h2>3. Create a remote user and grant privileges.</h2>

login to MySQL:

<code>mysql -u root -p mysql</code> (enter password after this)

Now write following commands:

<pre><code>CREATE USER 'jerry'@'localhost' IDENTIFIED BY 'jerrypassword';

CREATE USER 'jerry'@'%' IDENTIFIED BY 'jerrypassword';

GRANT ALL PRIVILEGES ON *.* to jerry@localhost IDENTIFIED BY 'jerrypassword' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* to jerry@'%' IDENTIFIED BY 'jerrypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

EXIT;
</code></pre>

After this, MySQL dB can be remotely accessed by entering public dns/ip of your instance as MySQL Host Address, username as jerry and password as jerrypassword. (Port is set to default at 3306)

blocks|key|2897948|text|对于ubuntu的某些配置，需要在该文件中更改bind-address：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2897949|/etc/mysql/mysql.conf.d/mysqld.cnf+|code-block|syntax|javascript|2897950|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For some configurations of ubuntu, the bind-address needs be changed in this file:

<pre><code>/etc/mysql/mysql.conf.d/mysqld.cnf 
</code></pre>

blocks|key|2897978|text|跟踪此问题的一个有用步骤是确定绑定地址MySQL实际设置为哪个绑定地址。您可以使用netstat来完成此操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2897979|netstat+-nat+%7Cgrep+:3306|code-block|syntax|javascript|2897980|这帮助我专注于我的问题，因为有多个mysql配置文件，而我编辑错了一个。Netstat显示mysql仍在使用错误的配置：|2897981|ubuntu@myhost:~$++netstat+-nat+%7Cgrep+:3306
tcp++++++++0++++++0+127.0.0.1:3306++++++++++0.0.0.0:*+++++++++++++++LISTEN|2897982|因此，我在config目录中查找可能会覆盖我的设置的任何其他文件，并找到：|2897983|ubuntu@myhost:~$++sudo+grep+-R+bind+/etc/mysql
/etc/mysql/mysql.conf.d/mysqld.cnf:bind-address+++++++++=+127.0.0.1
/etc/mysql/mysql.cnf:bind-address+=+0.0.0.0
/etc/mysql/my.cnf:bind-address+=+0.0.0.0|2897984|哦！这表明我调整的设置是错误的配置文件，所以这次我编辑了正确的文件，并使用netstat进行了确认，然后就可以运行了。|2897985|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

A helpful step in tracking down this problem is to identify which bind-address MySQL is actually set to. You can do this with netstat:

<pre><code>netstat -nat |grep :3306
</code></pre>

This helped me zero in on my problem, because there are multiple mysql config files, and I had edited the wrong one. Netstat showed mysql was still using the wrong config:

<pre><code>ubuntu@myhost:~$ netstat -nat |grep :3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
</code></pre>

So I grepped the config directories for any other files which might be overriding my setting and found:

<pre><code>ubuntu@myhost:~$ sudo grep -R bind /etc/mysql
/etc/mysql/mysql.conf.d/mysqld.cnf:bind-address = 127.0.0.1
/etc/mysql/mysql.cnf:bind-address = 0.0.0.0
/etc/mysql/my.cnf:bind-address = 0.0.0.0
</code></pre>

D'oh! This showed me the setting I had adjusted was the wrong config file, so I edited the RIGHT file this time, confirmed it with netstat, and was in business.

blocks|key|3112253|text|实例EC2+Ubuntu中Mysql的默认ip是127.0.0.1，如果你想更改它，只需按照这里已经给出的答案操作即可。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3112254|entityMap^0|O|9|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

The default ip of Mysql in instance EC2 
Ubuntu is <code>127.0.0.1</code> if you want to change it is just to follow the answers that have already been given here.

blocks|key|235901|text|我遇到的错误是，我的数据库网络设置允许到web的出站流量，但只允许来自选定IP地址的入站流量。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|235902|我添加了一个入站规则，以允许来自EC2的内网IP的流量，它起作用了。|235903|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|$]]

The error I was experiencing was that my database network settings allowed outbound traffic to the web – but inbound only from select IP addresses.
I added an inbound rule to allow traffic from my ec2's private IP and it worked.

blocks|key|2898152|text|在亚马逊EC2上更新新的MySQL+5.7|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2898153|etc/mysql中的my.cnf文件将只包含|2898154|!includedir+/etc/mysql/conf.d/
!includedir+/etc/mysql/mysql.conf.d/|code-block|syntax|javascript|2898155|不编辑此FILE....MYSQL将阻止更改|offset|length|style|BOLD|2898156|相反，只需转到/etc/mysql/mysql.conf.d/|CODE|2898157|在那里，您应该会找到一个名为mysqld.cnf的文件|2898158|在这里，你会发现|2898159|bind-address+=+127.0.0.1|2898160|将其更改为|2898161|bind-address+=+0.0.0.0+<OR>+<Your+IP>|2898162|就是这样！。保存文件并重新启动MYSQL。|2898163|不做任何其他更改，如“跳过网络”。这应该可以工作，|2898164|谢谢|2898165|entityMap^0|0|0|0|0|M|0|7|O|0|E|A|0|0|0|0|0|0|0|P|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1B|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1C|8|@$K|1D|L|1E|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1F|8|@$K|1G|L|1H|M|Q]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1I|8|@$K|1J|L|1K|M|Q]]|9|@]|A|$]]|$1|T|3|U|5|6|7|1L|8|@]|9|@]|A|$]]|$1|V|3|W|5|F|7|1M|8|@]|9|@]|A|$G|H]]|$1|X|3|Y|5|6|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|10|5|F|7|1O|8|@]|9|@]|A|$G|H]]|$1|11|3|12|5|6|7|1P|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|1Q|8|@$K|1R|L|1S|M|N]]|9|@]|A|$]]|$1|15|3|16|5|6|7|1T|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|18|$]]

Update on new MySQL 5.7 on AWS EC2
The my.cnf file in /etc/mysql will only be having
<pre><code>!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
</code></pre>
DO NOT EDIT THIS FILE....MYSQL WILL BLOCK THE CHANGE
Instead, just go to
<code>/etc/mysql/mysql.conf.d/</code>
There, you should find a file named <code>mysqld.cnf</code>
Here, you will find
<pre><code>bind-address = 127.0.0.1
</code></pre>
Change it to
<pre><code>bind-address = 0.0.0.0 &lt;OR&gt; &lt;Your IP&gt;
</code></pre>
THAT'S IT!!!. SAVE THE FILE AND RESTART MYSQL.
DO NOT DO ANY OTHER CHANGES LIKE 'SKIP-NETWORKING'. THIS SHOULD WORK
Thanks

blocks|key|2898178|text|下面是我使用Ec2上安装的MySQL进行远程连接时所遵循的步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2898179|2898180|在/etc/mysql/mysql.conf.d/mysqld.cnf中编辑以下行|ordered-list-item|2898181|2898182|绑定地址=+127.0.0.1到绑定地址=+0.0.0.0|2898183|2898184|创建新用户以从任何计算机远程连接到mysql。如果您只想从特定ip远程访问mysql，请提及机器IP，而不是‘%25’。|2898185|2898186|2898187|创建用户'master'@'%25‘，标识为'write-password-here'；使用GRANT+OPTION将db_name.*上的所有权限授予'master'@'%25’；|blockquote|2898188|2898189|2898190|在您的Ec2实例的安全组入站规则中，添加一个值为MYSQL/Aurora、TCP、3306和source=0.0.0.0/0的行|2898191|2898192|2898193|最后，通过以下方式从远程机器连接到MySQL|2898194|mysql+-u+master+-h+write-server-ip+-p|code-block|syntax|javascript|2898195|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|17|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|19|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|1B|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1H|8|@]|9|@]|A|$]]|$1|U|3|-4|5|E|7|1I|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|10|7|1L|8|@]|9|@]|A|$11|12]]|$1|13|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|14|$]]

Here are the steps I followed for remote connection with MySQL installed on Ec2:
<ol>
<li>Edit the following line in /etc/mysql/mysql.conf.d/mysqld.cnf
<pre><code>bind-address = 127.0.0.1

to

bind-address = 0.0.0.0
</code></pre>
</li>
<li>Create New user to remotely connect to mysql from any machine. Mention the machine ip instead of ‘%’ if you only wanted to remotely acces mysql from specific IP.
</li>
</ol>
<blockquote>
<pre><code>CREATE USER 'master'@'%' IDENTIFIED BY 'write-password-here';

GRANT ALL PRIVILEGES ON db_name.* TO 'master'@'%' WITH GRANT OPTION;
</code></pre>
</blockquote>
<ol start="3">
<li>In the inbound rules of the security group of your Ec2 instance add a row having values MYSQL/Aurora, TCP, 3306 and source=0.0.0.0/0</li>
</ol>
Finally connect with MySQL from the remote machine by
<pre><code>mysql -u master -h write-server-ip -p
</code></pre>

blocks|key|237611|text|适用于亚马逊EC2+Ubuntu+18.x和20.x|type|unstyled|depth|inlineStyleRanges|entityRanges|data|237612|237613|转到EC2控制台。转到|ordered-list-item|237614|，然后转到安全组。|237615|与您的实例关联的安全组|237616|编辑入站规则|237617|添加新规则。选择MySQL/Aurora，然后选择Source+to+anywhere.|237618|Finally遵循来自digital+ocean的教程，了解如何设置优化的远程数据库连接。|237619|237620|教程链接：https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql-on-ubuntu-18-04|offset|length|237621|entityMap|0|LINK|mutability|MUTABLE|url|https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql-on-ubuntu-18-04^0|0|0|0|0|0|0|0|0|0|5|3S|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|14|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|18|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|19|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@$S|1C|T|1D|1|1E]]|A|$]]|$1|U|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

For AWS EC2 Ubuntu 18.x and 20.x
<ol>
<li>Head over to the EC2 console.</li>
<li>Then to Security Groups.</li>
<li>The Security Group that is associated to your instance</li>
<li>Edit Inbound Rules</li>
<li>Add New Rule. Select MySQL/Aurora then select Source to anywhere.</li>
<li>Finally Follow this tutorial from digital ocean on how to setup a remote database connection that is optimised.</li>
</ol>
Tutorial link:
<a href="https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql-on-ubuntu-18-04" rel="nofollow noreferrer">https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql-on-ubuntu-18-04</a>

blocks|key|232145|text|简单的Hack|type|unstyled|depth|inlineStyleRanges|entityRanges|data|232146|232147|我们的EC2+MYSQL服务器将使用|ordered-list-item|232148|托管在remotehost:3306上|offset|length|style|CODE|232149|我们可以将这个远程端口转发到我们的localhost:3307，然后|232150|使用MYSQL工作台连接到`+`localhost:3307‘|232151|232152|请确保编辑ec2实例的入站规则以允许|232153|上的流量|232154|端口3306|232155|entityMap^0|0|0|0|3|F|0|H|E|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@$H|12|I|13|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|14|8|@$H|15|I|16|J|K]]|9|@]|A|$]]|$1|N|3|O|5|6|7|17|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|E|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1A|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1B|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|X|$]]

Simple Hack
<ol>
<li>Our EC2 MYSQL server will be hosted at <code>remotehost:3306</code> using</li>
</ol>
<code>port forwarding</code> we can forward this remote port to our <code>localhost:3307</code> and
the use MYSQL workbench to connect to `localhost:3307'
<ol start="2">
<li>Make sure to edit inbound rules of your ec2 instance to allow traffic on</li>
</ol>
port 3306

I want to connect to db on EC2 from my local machine, I am not able to do and have tried everything- 
I am using this command to connect to EC2:

<pre><code>mysql -uUSERNAME -hEC2_IP -pPASSWORD
</code></pre>

This error is generated 

<blockquote>
 ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (110)
</blockquote>

I have modified my.cnf with 

<pre><code>skip networking
bind-address = 0.0.0.0
</code></pre>

Still not able to connect to the database

Connect to mysql on Amazon EC2 from a remote server

数据库

服务器

防火墙

Ubuntu

MySQL

CIDR

我想要从我的本地计算机连接到EC2上的数据库，我无法这样做，并且已经尝试了所有方法-我正在使用以下命令连接到EC2：mysql -uUSERNAME -hEC2_IP -pPASSWORD生成此错误错误2003 (HY000)：无法连接到'IP‘上的MySQL服务器(110)我用以下命令修改了my.cnfskip ne...

问从远程服务器连接到亚马逊EC2上的mysql
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从远程服务器连接到亚马逊EC2上的mysqlEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从远程服务器连接到亚马逊EC2上的mysql
EN