<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除]]></title> 
<link>http://www.jackxiang.com/index.php</link> 
<description><![CDATA[赢在IT，Playin' with IT,Focus on Killer Application,Marketing Meets Technology.]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除]]></copyright>
<item>
<link>http://www.jackxiang.com/post//</link>
<title><![CDATA[[实践Ok]树莓派下mysql启动失败原因：Do you already have another mysqld server running on port: 3306 ?及apache也通过127.0.0.1无法访问的小问题备案。]]></title> 
<author>jack &lt;xdy108@126.com&gt;</author>
<category><![CDATA[数据库技术]]></category>
<pubDate>Sat, 17 Oct 2015 08:38:10 +0000</pubDate> 
<guid>http://www.jackxiang.com/post//</guid> 
<description>
<![CDATA[ 
	背景：Raspberry Pi下的mysql启动出现如下：<br/>151017&nbsp;&nbsp;8:33:10 [Note] Server socket created on IP: &#039;127.0.0.1&#039;.<br/>151017&nbsp;&nbsp;8:33:10 [ERROR] Can&#039;t start server: Bind on TCP/IP port: Cannot assign requested address<br/>151017&nbsp;&nbsp;8:33:10 [ERROR] Do you already have another mysqld server running on port: 3306 ?<br/><br/><br/>注意关键词 Bind<br/>　　这时，可以打开/etc/mysql/my.cnf<br/>　　...<br/>　　bind-address　 = 192.168.141.25<br/>　　...<br/>　　如果你也是这么写的，那么把它改成<br/>　　bind-address　 = 0.0.0.0<br/>　　然后重启即可<br/>　　另外，mysql在启动时进行了端口的bind，那么当ip更换时，请注意这些细节<br/><br/> vi /etc/mysql/my.cnf <br/><br/>#bind-address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 127.0.0.1<br/>bind-address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= 0.0.0.0<br/><br/>来自：http://www.educity.cn/wenda/403390.html<br/><br/>实际情况是因为自己把lo给干掉了，没有127.0.0.1这个端口：<br/>vi /etc/network/interfaces<br/>auto lo<br/>iface lo inet loopback<br/>....<br/><br/>同理，apache2也是一样的道理，因为这个软的IP，没有了，于是也没法访问，得特别注意：<br/> vi /etc/network/interfaces<br/><textarea name="code" class="php" rows="15" cols="100">
auto lo
iface lo inet loopback
auto wlan0
allow-hotplug wlan0
iface wlan0 inet dhcp
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wpa-ssid &quot;HiWiFi_256ECA&quot;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;wpa-psk &quot;XdXp***&quot;

iface eth0 inet static
address 192.168.2.2
netmask 255.255.255.0
gateway 192.168.2.11

</textarea>
]]>
</description>
</item><item>
<link>http://www.jackxiang.com/post//#blogcomment</link>
<title><![CDATA[[评论] [实践Ok]树莓派下mysql启动失败原因：Do you already have another mysqld server running on port: 3306 ?及apache也通过127.0.0.1无法访问的小问题备案。]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>http://www.jackxiang.com/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>