ContOs6下开启MySql远程

博主： banalala
发布时间：2016 年 06 月 17 日
2412 次浏览
暂无评论
1220字数
分类：

telnet 数据库发现不通后 查看vps的端口开放 


	 

<pre class="prettyprint lang-js linenums">netstat -antp | grep 3306</pre>
 

	确认是0.0.0.0监听即可，若是127.0.0.1需要修改mysql配置

 

	Solution：进入到mysql的配置文件所在目录（/etc/mysql/my.cnf）


	找到文件中如下内容：&nbsp;


	 

<pre class="prettyprint lang-js linenums"># Instead of skip-networking the default is now to listen only on 
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1 </pre>
<pre class="prettyprint lang-js linenums">&nbsp;将bind-address注释掉，或者改成客户端主机IP</pre>

	 


	 


	&nbsp;如果是0.0.0.0需要修改防火墙


	添加规则，打开3306端口 

<ol start="1" class="dp-xml" style="padding:0px;border:none;color:#5C5C5C;font-family:Consolas, &quot;line-height:26px;white-space:normal;margin:0px 0px 1px 45px !important;background-color:#FFFFFF;">
	<li class="alt" style="border-left-width:3px;border-style:none none none solid;border-left-color:#6CE26C;list-style:decimal-leading-zero outside;color:inherit;line-height:18px;margin:0px !important;padding:0px 3px 0px 10px !important;">
		iptables&nbsp;-I&nbsp;INPUT&nbsp;-p&nbsp;tcp&nbsp;-m&nbsp;state&nbsp;--state&nbsp;NEW&nbsp;-m&nbsp;tcp&nbsp;--dport&nbsp;3306&nbsp;-j&nbsp;ACCEPT &nbsp; 
	</li>
</ol>

	 


	查看规则是否生效 

<ol start="1" class="dp-xml" style="padding:0px;border:none;color:#5C5C5C;font-family:Consolas, &quot;line-height:26px;white-space:normal;margin:0px 0px 1px 45px !important;background-color:#FFFFFF;">
	<li class="alt" style="border-left-width:3px;border-style:none none none solid;border-left-color:#6CE26C;list-style:decimal-leading-zero outside;color:inherit;line-height:18px;margin:0px !important;padding:0px 3px 0px 10px !important;">
		iptables&nbsp;-L&nbsp;-n &nbsp; 
	</li>
</ol>

	 


	上面使用iptables添加/删除规则都是临时的，如果需要重启也生效，就要保存修改 


	 

<ol start="1" class="dp-xml" style="padding:0px;border:none;color:#5C5C5C;font-family:Consolas, &quot;line-height:26px;white-space:normal;margin:0px 0px 1px 45px !important;background-color:#FFFFFF;">
	<li class="alt" style="border-left-width:3px;border-style:none none none solid;border-left-color:#6CE26C;list-style:decimal-leading-zero outside;color:inherit;line-height:18px;margin:0px !important;padding:0px 3px 0px 10px !important;">
		service&nbsp;iptables&nbsp;save&nbsp;//或者&nbsp;/etc/init.d/iptables&nbsp;save &nbsp; 
	</li>
</ol>
 

	 
 


	 
 

例外一种方式也可以实现： 

	 


	 

<ol start="1" class="dp-xml" style="padding:0px;border:none;color:#5C5C5C;font-family:Consolas, &quot;line-height:26px;white-space:normal;margin:0px 0px 1px 45px !important;background-color:#FFFFFF;">
	<li class="alt" style="border-left-width:3px;border-style:none none none solid;border-left-color:#6CE26C;list-style:decimal-leading-zero outside;color:inherit;line-height:18px;margin:0px !important;padding:0px 3px 0px 10px !important;">
		vi&nbsp;/etc/sysconfig/iptables&nbsp;//打开配置文件&nbsp;&nbsp; 
	</li>
</ol>

	 


	 

<ol start="1" class="dp-xml" style="padding:0px;border:none;color:#5C5C5C;font-family:Consolas, &quot;line-height:26px;white-space:normal;margin:0px 0px 1px 45px !important;background-color:#FFFFFF;">
	<li class="alt" style="border-left-width:3px;border-style:none none none solid;border-left-color:#6CE26C;list-style:decimal-leading-zero outside;color:inherit;line-height:18px;margin:0px !important;padding:0px 3px 0px 10px !important;">
		-A&nbsp;INPUT&nbsp;-p&nbsp;tcp&nbsp;-m&nbsp;state&nbsp;--state&nbsp;NEW&nbsp;-m&nbsp;tcp&nbsp;--dport&nbsp;3306&nbsp;-j&nbsp;ACCEPT &nbsp;//添加这条规则 
	</li>
</ol>
然后qw

	 


	 

<ol start="1" class="dp-xml" style="font-size:14px;line-height:26px;white-space:normal;padding:0px;border:none;font-family:Consolas, &quot;margin:0px 0px 1px 45px !important;background-color:#FFFFFF;">
	<li class="alt" style="border-left-width:3px;border-style:none none none solid;border-left-color:#6CE26C;list-style:decimal-leading-zero outside;line-height:18px;margin:0px !important;padding:0px 3px 0px 10px !important;">
		service&nbsp;iptables restart//重启 
	</li>
</ol>

最后修改：1970 年 01 月 01 日