<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title>BB的WEB开发笔记</title>
		<link>http://www.hzw513.com/</link>
		<description>web开发 Django开发交流群:19525555</description>
		<copyright>Copyright (C) 2004 Security Angel Team [S4T] All Rights Reserved.</copyright>
		<generator>SaBlog-X Version 1.6 Build 20080806</generator>
		<lastBuildDate>Mon, 06 Sep 2010 14:49:36 +0000</lastBuildDate>
		<ttl>30</ttl>
		<item>
			<guid>http://www.hzw513.com/show-40-1.html</guid>
			<title>MySQL忘记root密码</title>
			<author>BB</author>
			<description><![CDATA[<p>查了下资料,很多人说用 <span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Verdana,Arial,Helvetica,sans-serif; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: center; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" class="Apple-style-span"><span style="color: rgb(17, 17, 17); font-size: 14px; line-height: 25px; text-align: left;" class="Apple-style-span">mysqld_safe命令可以,<br />
但是,我试了,用这个启动mysql之后,执行mysql命令,不能获取锁<br />
<br />
不过还有一种方法,和上面的命令其实是一样的<br />
</span></span></p>
<ol>
    <li>stop mysqld</li>
    <li>修改 my.cnf : 在[<span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" class="Apple-style-span"><span style="color: rgb(42, 42, 42); font-family: Tahoma,Helvetica,Arial,sans-serif; font-size: 14px; line-height: 25px; text-align: left; text-indent: 28px;" class="Apple-style-span">mysqld</span></span>]字段加入<strong> skip-grant-tables</strong></li>
    <li>start mysqld</li>
    <li>这样就可以直接进入mysql了&nbsp; mysql -u root</li>
    <li>
    <div class="codeText">
    <div class="codeHead">SQL代码</div>
    <ol start="1" class="dp-sql">
        <li class="alt"><span><span class="keyword">UPDATE</span><span>&nbsp;mysql.</span><span class="func">user</span><span>&nbsp;</span><span class="keyword">SET</span><span>&nbsp;</span><span class="keyword">Password</span><span>=</span><span class="keyword">PASSWORD</span><span>(</span><span class="string">'password'</span><span>)&nbsp;</span><span class="keyword">WHERE</span><span>&nbsp;</span><span class="func">User</span><span>=</span><span class="string">'root'</span><span>;&nbsp;&nbsp;</span></span></li>
    </ol>
    </div>
    </li>
    <li><span><span>
    <div class="codeText">
    <div class="codeHead">SQL代码</div>
    <ol start="1" class="dp-sql">
        <li class="alt"><span><span>FLUSH&nbsp;</span><span class="keyword">PRIVILEGES</span><span>;&nbsp;&nbsp;</span></span></li>
    </ol>
    </div>
    </span></span></li>
    <li><span><span><span><span>恢复my.cnf</span></span></span></span></li>
    <li><span><span><span><span>restart mysqld</span></span></span></span></li>
</ol>
<p>其中,第二步是以不检查权限的方式启动mysql</p>]]></description>
			<link>http://www.hzw513.com/show-40-1.html</link>
			<category domain="http://www.hzw513.com/category-4-1.html">MySQL</category>
			<pubDate>2010-01-14 23:14</pubDate>
		</item>
		<item>
			<guid>http://www.hzw513.com/show-29-1.html</guid>
			<title>Navicat -- MySQL界面管理工具</title>
			<author>BB</author>
			<description><![CDATA[<p>今天粗略使用了Navicat ,总体感觉不错!</p>
<p>而且有免费版本</p>
<p>总结一下初步感受:</p>
<ol>
    <li>界面比较清爽</li>
    <li>启动速度快,占用的资源比较少</li>
    <li>有中文版本</li>
    <li>集成常用的命令按钮,很方便</li>
</ol>
<p>继续试用中......</p>]]></description>
			<link>http://www.hzw513.com/show-29-1.html</link>
			<category domain="http://www.hzw513.com/category-4-1.html">MySQL</category>
			<pubDate>2009-10-09 21:40</pubDate>
		</item>
		<item>
			<guid>http://www.hzw513.com/show-21-1.html</guid>
			<title>MySQL备份 ---- 文本文件</title>
			<author>BB</author>
			<description><![CDATA[<p>把数据库内容按指定格式备份到文本文件中!</p><br /><br /><a href="http://www.hzw513.com/show-21-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://www.hzw513.com/show-21-1.html</link>
			<category domain="http://www.hzw513.com/category-4-1.html">MySQL</category>
			<pubDate>2009-08-04 18:33</pubDate>
		</item>
		<item>
			<guid>http://www.hzw513.com/show-11-1.html</guid>
			<title>获取MySQL数据库大小</title>
			<author>BB</author>
			<description><![CDATA[<p>计算mysql数据库大小的 php 代码</p><br /><br /><a href="http://www.hzw513.com/show-11-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://www.hzw513.com/show-11-1.html</link>
			<category domain="http://www.hzw513.com/category-4-1.html">MySQL</category>
			<pubDate>2009-06-06 10:18</pubDate>
		</item>
	</channel>
</rss>
