如何开启MYSQL远程连接权限_MySQL

bitsCN.com

开启MYSQL远程连接权限

<ol style="border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: 19px; vertical-align: baseline; margin: 0px; padding: 0px 0px 0px 27px; list-style-position: initial; list-style-image: initial; color: #aeaeae;">
<li value="1" style="border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: 16px; vertical-align: baseline; margin: 0px; padding: 0px; list-style: decimal;">//建议设置固定IP</li>
<li style="border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: 16px; vertical-align: baseline; margin: 0px; padding: 0px; list-style: decimal;">mysql> GRANT ALL PRIVILEGES ON *.* TO root@"8.8.8.8" IDENTIFIED BY "root";</li>
<li style="border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: 16px; vertical-align: baseline; margin: 0px; padding: 0px; list-style: decimal;">mysql> flush privileges;</li>
<li style="border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: 16px; vertical-align: baseline; margin: 0px; padding: 0px; list-style: decimal;">//修改防火墙</li>
<li style="border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: 16px; vertical-align: baseline; margin: 0px; padding: 0px; list-style: decimal;">iptables -I INPUT -p tcp --dport 3306 -j ACCEPT</li>
</ol>

bitsCN.com