<?xml version="1.0" encoding="UTF-8"?>
  <feed xmlns="http://www.w3.org/2005/Atom">
  <title type="html"><![CDATA[蜗牛快递]]></title>
  <subtitle type="html"><![CDATA[孤独就像这与生俱来的壳，但也唯有依赖这束缚而生存]]></subtitle>
  <id>http://www.guende.com/</id> 
  <link rel="alternate" type="text/html" href="http://www.guende.com/" /> 
  <link rel="self" type="application/atom+xml" href="http://www.guende.com/atom.asp" /> 
  <generator uri="http://www.pjhome.net/" version="2.4.1022">PJBlog2</generator> 
  <updated>2008-06-19T09:19:28+08:00</updated> 

  <entry>
	  <title type="html"><![CDATA[综合几点对Resin与Tomcat的比较]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=9" label="平台┊服务器之技术" /> 
	  <updated>2008-06-19T09:19:28+08:00</updated>
	  <published>2008-06-19T09:19:28+08:00</published>
		  <summary type="html"><![CDATA[<p><br />1.resin对中文支持比较好，但是代码设计得比较糟糕，商用较多。&nbsp;&nbsp; <br />&nbsp;&nbsp; tomcat的设计比较规范，是java研究组织的产物，个人研究用得较多.</p>
<p>2.如果写Bean或servlet的话,在Resin下,直接修改*.java文件就行了,Resin如果</p>
<p>发现站点中的*.java文件被修改,会自动编译成新的class文件的.而tomcat要自己</p>
<p>手工地编译新的*.java文件 .</p>
<p>3.resin处理html的速度好像比tomcat快，tomcat在重负荷下</p>
<p>4.对中文的支持resin表现的最出色，而且比tomcat速度快三倍，而且无须配置.<br /></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=436" /> 
	  <id>http://www.guende.com/default.asp?id=436</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[美博客批微软利用专利权阻碍开源社区发展]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=4" label="业内信息" /> 
	  <updated>2008-05-26T09:39:35+08:00</updated>
	  <published>2008-05-26T09:39:35+08:00</published>
		  <summary type="html"><![CDATA[　　开源软件公司Alfresco高管马特-艾塞（Matt Asay）5月25日在博客中撰文，对微软利用专利权阻碍开源社区发展的做法提出批评，并呼吁微软尽快接受开源软件。<br /><br />　　艾塞表示，微软平台技术高级总监萨姆-拉姆齐（Sam Ramji）等人曾推动微软在开源方面的发展，然而微软却以专利权问题为由为开源软件的发展设置障碍。<br /><br />　　目前并不清楚微软为何对开源持抗拒态度。不过，教条主义很可能是促使微软独自&ldquo;对抗&rdquo;开源的主要原因。艾塞表示，自己曾经计划加盟微软，但是微软拒绝开源的态度打消了他的计划。而与他类似的情况还有很多。<br /><br />　　微软曾经与Zend、SugarCRM、MySQL和JBoss等开源软件公司进行过合作，但是双方的合作更多的是关于专利的问题，而不是达成更重要的互操作协议。艾塞表示，微软的做法&ldquo;玷污&rdquo;了曾经涉及过的开源合作。<br /><br />　　在宣称Linux侵犯了自己的专利权之后，微软就很少与开源社区合作。微软曾经与使用Linux系统的亚洲OEM厂商合作，但是仍拒绝主流的开源创业企业。<br />　　<br />　　艾塞表示，许多商业性的开源软件公司都在业务模型中集成了私有和开源两方面的授权模式，因此微软也可以在不放弃现有营收模型的情况下接受开源社区。微软需要做的将是软化在专利权方面的立场，而微软也不会因此蒙受损失。]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=435" /> 
	  <id>http://www.guende.com/default.asp?id=435</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[Ubuntu如此带动Linux向Windows擅长的的桌面市场扩张是坏是好？]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=21" label="系统┊操作系统相关" /> 
	  <updated>2008-05-23T11:12:54+08:00</updated>
	  <published>2008-05-23T11:12:54+08:00</published>
		  <summary type="html"><![CDATA[突然间的几年Ubuntu怎么就变成了一件时尚的东西了。现在凡是关于操作系统的新闻除了Windows就数Ubuntu了。书店里居然也有了Ubuntu的中文出版物，网上是铺天盖地的Ubuntu的新闻，哎曝光率极高，貌似看到过很多人在用Ubuntu了，怎么也不明白Ubuntu就瞬间流行了起来，这几年的变化太快了完全看不懂了。这两年不能否认Linux 的扩张速度的确够快，那要完全归功于Ubuntu，但是至少在我心中Linux已经颠覆了她本来的形象。<br /><br />想当年买RedHat9.0盒装版开始接触Linux时整个中国没多少人在用linux，想当年软件店里红色经典的RedHat盒装版布满灰尘，几乎要被遗忘了。那时感觉linux在中国前途黯淡呐。但现在呢，居然是另一种景象，linux几乎要被人成为windows桌面外的第二选择了，GUI, GUI，人们为了方便，为了图形化界面也许根本不会去关心Unix的文件系统结构，进程，作业调度，基于进程驱动的unix的强大功能，而开始像 Windows那样随心所欲的安装软件，用鼠标随意的点两下就OK，天哪这还是linux吗。<br /><br />随意的扩张，忽视潜在的威胁必会带来负面影响，就像当年OpenBSD的创始人theo de raadt嘲笑linux在朝另一个微软发展，嘲笑linux质量低劣。现在看来就是如此，越来越流行，越来越庞大，质量也越来越差，商业味也越来越浓，这还是linux开源的初衷吗？<br /><br />Linux迅速扩张，迅速抢占一块又一块的市场，但流行了就会带来威胁，还是低调点吧！Unix的初衷是小即是美，这一点从她诞生之日起就是如此，未来也不会改变！<br /><br />编者按：其实就编者看来Ubuntu如此带动Linux向Windows擅长的的桌面市场扩张，并非是件坏事，至少让一些只是拿电脑来完成一些基本工作，像上网，编辑文档，听歌，看电影的需求的用户更多了一种选择。那又怎么就不是Linux和开源软件的初衷呢？<br /><br />Linux在向桌面市场扩张的同时，并没有忘记自己的老本行&mdash;&mdash;Linux服务器的工作。至少Redhat在我们印象中仍然是把工作重心放在服务器系统上。我们同样不能说Ubuntu现在已经是放弃了服务器领域，就拿刚刚发布的Ubuntu 8.04 LTS版来讲，Ubuntu的服务器版本还是没有少，支持年限（2013年）也比桌面版本（2011年）长两年。个人认为Linux正在朝两个方面发展，一个方向，针对服务器的版本仍然向着更高效执行率，更低系统消耗，更长的稳定性的方向发展；而另一个方向就是针对桌面的Linux普通用户的向着更简单易用，更美观炫目的方向发展。这样又何尝不是Linux的一种新的出路呢。]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=434" /> 
	  <id>http://www.guende.com/default.asp?id=434</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[FileZilla - 开源的FTP客户端]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=8" label="软件技术" /> 
	  <updated>2008-05-22T07:23:22+08:00</updated>
	  <published>2008-05-22T07:23:22+08:00</published>
		  <summary type="html"><![CDATA[<p>FileZilla是一个免费开源的FTP客户端软件,分为客户端版本和服务器版本,具备所有的FTP软件功能.可控性、有条理的界面和管理多站点的简化 方式使得Filezilla客户端版成为一个方便高效的FTP客户端工具,而FileZilla Server则是一个小巧并且可靠的支持FTP&amp;SFTP的FTP服务器软件.<br /><br /></p>
<p>Changes in FileZilla 3.0.10, (2008-05-20):<br />- Precompiled binaries available from filezilla-project.org now link against GnuTLS 2.2.5 due to security vulnerabilities in previous GnuTLS versions, see http://www.gnu.org/software/gnutls/security.html </p>
<p>Homepage - http://sourceforge.net/projects/filezilla </p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=433" /> 
	  <id>http://www.guende.com/default.asp?id=433</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[CentOS 5 下 VSFTP 服务器架设详细过程（虚拟用户指定上传目录）]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=21" label="系统┊操作系统相关" /> 
	  <updated>2008-05-21T11:42:20+08:00</updated>
	  <published>2008-05-21T11:42:20+08:00</published>
		  <summary type="html"><![CDATA[<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;为了配置好服务器上的</span><span lang="EN-US"><font face="Times New Roman">FTP</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">服务器，折磨了我好几天时间了，昨天坐电脑面前调试了一天，搞得晚上都没睡好。今天又是一个上午，终于把问题全部解决了。特此把架设的过程写出来，以便大家从中得到启发</span><span lang="EN-US"><font face="Times New Roman">.</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 15.75pt; mso-char-indent-count: 1.5"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">注意：本人使用的服务器发行版本：</span><span lang="EN-US"><font face="Times New Roman">CentOS 5 </font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">．首先自然是安装</span><span lang="EN-US"><font face="Times New Roman">VSFTP</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">软件包了。这一步我就不废话了。我采用的是</span><span lang="EN-US"><font face="Times New Roman">RPM</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">安装方法。你用什么安装方法都一样。顺便记录下，如果你用的是二进制包的话，</span><span lang="EN-US"><font face="Times New Roman">(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">让</span><span lang="EN-US"><font face="Times New Roman">VsFTPD </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">作为一个系统的独立服务的话</span><span lang="EN-US"><font face="Times New Roman">)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">可能要用到以下几个命令：</span><span lang="EN-US"><font face="Times New Roman">chkconfig add vsftpd<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>chkconfig vsftpd on<span style="mso-spacerun: yes">&nbsp; </span>chkconfig &ndash;list vsftpd</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span lang="EN-US"><font face="Times New Roman">2.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">下面正式开始</span><span lang="EN-US"><font face="Times New Roman">vsftp </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中配置虚拟用户的</span><span lang="EN-US"><font face="Times New Roman">FTP</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">服务器：</span></font></p>
</span></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5"><font size="3"><span lang="EN-US"><font face="Times New Roman">vsftp</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的虚拟采用了不与系统账户口令合二为一的方法，也就是说，为了认证这些虚拟用户</span><span lang="EN-US"><font face="Times New Roman">vsftp</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">采用单独的口令文件</span><span lang="EN-US"><font face="Times New Roman">(pam_userdb)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">，由可插入论证模块进行认证。保用这种方法更安全也更灵活。</span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">具体的方法：</span><font face="Times New Roman"> </font></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 14.25pt"><font size="3"><span lang="EN-US"><font face="Times New Roman">1.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">生成虚拟用户的口令文件。</span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 14.25pt"><font size="3"><span lang="EN-US"><font face="Times New Roman">2.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">配置生成</span><span lang="EN-US"><font face="Times New Roman">vsftp</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的认证文件。</span><span lang="EN-US"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 14.25pt"><font size="3"><span lang="EN-US"><font face="Times New Roman">3.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">建立虚拟用户的目录并设置相应的权限。</span><span lang="EN-US"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 14.25pt"><font size="3"><span lang="EN-US"><font face="Times New Roman">4.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">建立配置文件。</span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">首先建立一个</span><span lang="EN-US"><font face="Times New Roman">txt</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">文本文件：</span><span lang="EN-US"><font face="Times New Roman">vi login.txt</font></span></font></p>
</span></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><font size="3">在文本文件中输入：</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">&gt;guende</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">&gt;password</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">&gt;infoadmin</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">&gt;password</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><font size="3">注：在该文件中奇数行为用户名，偶数行为密码。</font></span><span lang="EN-US"><br /></span><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">把该文件生成口令文件</span><span lang="EN-US"><font face="Times New Roman">:</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">db_load -T -t hash -f ~/logins.txt /etc/vsftpd/vsftpd_login.db<br />chmod 600 /etc/vsftpd/vsfpd_login.db</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">生成虚拟用户所需要的</span><span lang="EN-US"><font face="Times New Roman">PAM</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">配置文件</span></font><span lang="EN-US"><br /><font face="Times New Roman" size="3">#vi /etc/pam.d/vsftp.vu<br />auth required pam_userdb.so db=/etc/vsftpd/vsftpd_login<br />account required pam_userdb.so db=/etc/vsftpd/vsftpd_login<br /></font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><font size="3">保存退出</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">建立虚拟用户所要访问的目录并设置仅</span><span lang="EN-US"><font face="Times New Roman">virtual</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用户访问的权限。</span></font><span lang="EN-US"><br /><font face="Times New Roman" size="3">#useradd -d /home/infoadmin virtual<br />#chmod 704 /home/infoadmin</font></span></p>
</span></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">修改</span><span lang="EN-US"><font face="Times New Roman">/etc/vsftp/vsftpdconf</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">文件，使其保证有以下配置语句</span></font><span lang="EN-US"><br /><font face="Times New Roman" size="3">listen=YES<br />anonymouse_enable=NO<br />local_enable=YES<br />write_enable=NO<br />anon_uplaod_enable=NO<br />anon_mkdir_write_enable=NO<br />anon_other_write_enable=NO<br />one_porcess_model=NO<br />chroot_local_user=YES<br />ftpd_banner=this ftp server is virtual user only<br />guest_enable=YES</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><font size="3">（启用虚拟用户）</font></span><span lang="EN-US"><br /><font face="Times New Roman" size="3">guest_username=virtual</font></span><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（将虚拟用户映射为本地</span><span lang="EN-US"><font face="Times New Roman">virtual</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用户。</span></font><span lang="EN-US"><br /><font face="Times New Roman" size="3">pam_service_name=vsftp.vu</font></span></p>
</span></p>
<p>&nbsp;</p>
<p><span lang="EN-US"></span><span lang="EN-US"><font face="Times New Roman" size="3">Virtual_use_local_privs=YES</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">User_config_dir=/etc/vftp</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><font size="3">保存退出</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</span><span lang="EN-US"><font face="Times New Roman">/etc</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">目录下建立目录：</span><span lang="EN-US"><font face="Times New Roman">mkdir /etc/vftp</font></span></font></p>
</span></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">进入该目录下，建立与虚拟用户名字一致的文件，（利用此文件对具体虚拟用户的权限进行分配和控制），如：</span><span lang="EN-US"><font face="Times New Roman">touch infoadmin</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">然后：</span><span lang="EN-US"><font face="Times New Roman">vi /etc/ftp/infoadmin</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">加入以下一行：</span><span lang="EN-US"><font face="Times New Roman">local_root=/home/infoadmin</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">进入</span><span lang="EN-US"><font face="Times New Roman">/home<span style="mso-spacerun: yes">&nbsp; </span>:cd /home</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">建立</span><span lang="EN-US"><font face="Times New Roman">infoadmin</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">目录：</span><span lang="EN-US"><font face="Times New Roman">mkdir infoadmin</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">修改该目录的归属：</span><span lang="EN-US"><font face="Times New Roman">chown virtual.virtual infoadmin</font></span></font></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span lang="EN-US"><font face="Times New Roman">OK ,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">最后</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">打开编辑：</span><span lang="EN-US"><font face="Times New Roman">vi /etc/selinux/config</font></span></font></p>
</span></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">SELINUX=permissive</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><font face="Times New Roman" size="3">SELINUX=targeted</font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><font size="3"><span lang="EN-US"><font face="Times New Roman">OK,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">最后：</span><span lang="EN-US"><font face="Times New Roman">service vsftpd restart</font></span></font></p>
</span></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US">
<p><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><font size="3">大功告成！</font></span></p>
</span></p>
<p>&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=432" /> 
	  <id>http://www.guende.com/default.asp?id=432</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[linux操作系统极可能使用ZFS文件系统]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=21" label="系统┊操作系统相关" /> 
	  <updated>2008-05-21T08:26:46+08:00</updated>
	  <published>2008-05-21T08:26:46+08:00</published>
		  <summary type="html"><![CDATA[<p>被视为终极文件系统的ZFS很长一段时间以来一直是Linux使用者梦寐以求的一项技术，但是由于Sun在ZFS上拥有56项专利，只同意以CDDL开源方式移植，所以无法在使用GPL协议的Linux上直接实现。</p>
<p>不过，这种情况也许就要改变，昨天，ZFS的领导开发者Jeff Bonwick和Linus在家中见了面，喝了酒，Jeff Bonwick最后对关注两人会晤的读者们表示&ldquo;敬请期待&rdquo;。也许过不了多久Linux的使用者就不用再羡慕FreeBSD和Mac OS X了。</p>
<p>ZFS是Sun公司Jeff Bonwick在领导开发的一种128位文件系统，最早宣布于04年9月，代表&quot;Zettabyte File System&quot;, 具有18.4 &times; 10e18倍于当前64位文件系统的储存能力，Bonwick说要填满一个128位的文件系统，将耗尽地球上所有存储设备。除非拥有煮沸整个海洋的能量，不然不可能将其填满。</p>
<p>除了拥有近乎无限的储存能力，ZFS还不同于传统文件系统需要驻留于单独设备或需要卷管理系统，ZFS建立在虚拟的存储池上。文件系统不再仅限于单个设备，从而可与池中的所有文件系统共享空间。使用者不再需要预先确定文件系统的大小，因为文件系统会在分配给存储池的空间内自动增长。添加新存储器后，也无需执行其他操作，池中的所有文件系统即可立即使用新增的空间。</p>
<p>另外，ZFS是事务性文件系统，使用写复制（copy-on-write）语义，文件系统状态在磁盘上始终一致，任何操作序列会全部被提交或全部被忽略。这意味着文件系统绝对不会因意外断电或系统崩溃而被损坏，同时还避免了日志文件系统写两次的额外开销。</p>
<p>ZFS还具有独特的校验、自我修复和快照等功能。</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=431" /> 
	  <id>http://www.guende.com/default.asp?id=431</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[新型文件系统ZFS]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=21" label="系统┊操作系统相关" /> 
	  <updated>2008-05-21T08:12:08+08:00</updated>
	  <published>2008-05-21T08:12:08+08:00</published>
		  <summary type="html"><![CDATA[<span class="postbody">ZFS 是一种新型文件系统，可提供简单管理、事务性语义、端对端数据完整性以及极好的可伸缩性。ZFS 并不是在现有技术的基础上逐步改进而得到的，它是一种全新的数据管理方法。我们摒弃了 20 年来的传统观念，大大降低了源代码的复杂性，创建了一种真正易于使用的存储系统。 <br /><br />ZFS 提供了池存储模型，完全淘汰了卷的概念，并避免了与分区、置备、带宽浪费和分散存储相关的问题。数千个文件系统可以利用同一个公用存储池，每个文件系统只占用实际所需的空间量。存储池中所有设备的 I/O 组合带宽对所有文件系统都始终可用。 <br /><br />所有操作都是写复制事务，因此盘上状态始终有效。ZFS 文件系统不需要 fsck(1M)。每个块都经过校验和计算，以防止无提示数据损坏，并且数据在复制（镜像或 RAID）配置中可以自我修复。如果其中一个副本损坏，ZFS 会检测到这种情况，并使用另一个副本修复它。 <br /><br />ZFS 引入了一个新的数据复制模型，称为 RAID-Z。它与 RAID-5 类似，但采用可变条带宽度来消除 RAID-5 写入漏洞（即由于数据和奇偶校验更新之间出现意外断电而导致条带损坏）。所有 RAID-Z 写操作都是完整条带化写操作。这样，既没有读取-修改-写入开销，也没有写入漏洞，并且最重要的一点是不需要 NVRAM 硬件。ZFS 偏爱廉价磁盘。 <br /><br />但由于廉价磁盘容易出现故障，因此 ZFS 提供了磁盘清理功能。就像 ECC 内存清理一样，其理念是读取所有数据以检测潜在错误，而这些错误仍是可更正的。清理操作将遍历整个存储池，以读取每个块的每个副本，根据其 256 位校验和对其进行验证，并在必要时进行修复。所有这些操作都是在存储池运行和使用过程中进行的。 <br /><br />ZFS 有一个管道化 I/O 引擎，它在概念上与 CPU 管道类似。管道作用于 I/O 依赖关系图，并提供记分板、优先级、最终期限调度、失序发射和 I/O 聚合。使用 ZFS I/O 管道，可以轻松处理使其他文件系统濒临崩溃的 I/O 负载。 <br /><br />ZFS 提供了无限制的常量时间快照和克隆。快照是文件系统的只读即时副本，而克隆是快照的可写副本。克隆提供了一种极其节省空间的方法，可用于存储工作区、软件安装和无盘客户端等主要共享数据的许多副本。 <br /><br />ZFS 备份和恢复由快照提供支持。任一快照都可生成完全备份，任意一对快照都可生成增量备份。增量备份效率很高，可用于远程复制－例如每 10 秒传送一个增量更新。 <br /><br />在 ZFS 中没有任何限制。您可以拥有任意多个文件、完整 64 位文件偏移、无限制的链接、目录条目、快照等等。 <br /><br />ZFS 提供了内置压缩。压缩不但将磁盘空间的使用量降低了 2-3 倍，还将 I/O 量减少了 2-3 倍。因此，启用压缩实际上能够提高某些工作负荷的运行速度。 <br /><br />除文件系统外，ZFS 存储池可为需要原始设备语义的应用程序提供卷。例如，ZFS 卷可用作交换设备。如果在交换卷上启用压缩，您将立即拥有压缩虚拟内存。</span>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=430" /> 
	  <id>http://www.guende.com/default.asp?id=430</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[SELinux ]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=21" label="系统┊操作系统相关" /> 
	  <updated>2008-05-20T13:26:44+08:00</updated>
	  <published>2008-05-20T13:26:44+08:00</published>
		  <summary type="html"><![CDATA[<strong>SELinux(Security-Enhanced Linux)</strong> 是美国国家安全局（NAS）对于强制访问控制的实现，是 Linux&amp;reg; 上最杰出的新安全子系统。NSA是在Linux社区的帮助下开发了一种访问控制体系，在这种访问控制体系的限制下，进程只能访问那些在他的任务中所需要文件。SELinux 默认安装在 Fedora 和 Red Hat Enterprise Linux 上，也可以作为其他发行版上容易安装的包得到。<br /><br />&nbsp; &nbsp;&nbsp; &nbsp;SELinux 是 2.6 版本的 Linux 内核中提供的强制访问控制 (MAC)系统。对于目前可用的 Linux 安全模块来说，SELinux 是功能最全面，而且测试最充分的，它是在 20 年的 MAC 研究基础上建立的。SELinux 在类型强制服务器中合并了多级安全性或一种可选的多类策略，并采用了基于角色的访问控制概念。<br /><br />&nbsp; &nbsp;&nbsp; &nbsp;大部分使用 SELinux 的人使用的都是 SELinux 就绪的发行版，例如 Fedora、Red Hat Enterprise Linux (RHEL)、Debian 或 Gentoo。它们都是在内核中启用 SELinux 的，并且提供一个可定制的安全策略，还提供很多用户层的库和工具，它们都可以使用 SELinux 的功能。<br /><br />&nbsp; &nbsp;&nbsp; &nbsp;SELinux是一种基于 域-类型 模型（domain-type）的强制访问控制（MAC）安全系统，它由NSA编写并设计成内核模块包含到内核中，相应的某些安全相关的应用也被打了SELinux的补丁，最后还有一个相应的安全策略。<br /><br />&nbsp; &nbsp;&nbsp; &nbsp;众所周知，标准的UNIX安全模型是&quot;任意的访问控制&quot;DAC。就是说，任何程序对其资源享有完全的控制权。假设某个程序打算把含有潜在重要信息的文件扔到/tmp目录下，那么在DAC情况下没人能阻止他！<br /><br />&nbsp; &nbsp;&nbsp; &nbsp;而MAC情况下的安全策略完全控制着对所有资源的访问。这是MAC和DAC本质的区别。<br /><br />&nbsp; &nbsp;&nbsp; &nbsp;SELinux提供了比传统的UNIX权限更好的访问控制。 <br /><br />1.背景<br />SELinux是「Security-Enhanced Linux」的简称，是美国国家安全局「NSA＝The National Security Agency」 和SCC（Secure Computing Corporation）开发的 Linux的一个扩张强制访问控制安全模块。原先是在Fluke上开发的，2000年以 GNU GPL 发布。<br /><br />现在以Linux作为因特网服务器是越来越普遍的事了。在我这几年作过的项目里，WEB的开发基本都是基于Linux的，这里有给大公司做的，也给政府部门做的，当然更多的是中小企业做的。这其中给政府做的，我们把SELinux作为一个卖点，接受了不少项目。<br /><br />2.我们需要安全操作系统的理由<br />现在不论是政府还是民间企业，大家对信息安全问题是越来越关心了，因为企业的业务平台的服务器上存储着大量的商务机密，个人资料，个人资料它直接关系到个人的隐私问题。特别是我们政府的网站，作为信息公开的平台，它的安全就更显得重要了。这些连到互联网的服务器，不可避免的要受到来自世界各地的各种威胁。最坏的时候我们的服务器被入侵，主页文件被替换，机密文件被盗走。除了来自外部的威胁外，内部人员的不法访问，攻击也是不可忽视的。对于这些攻击或者说是威胁，当然有很多的办法，有防火墙，入侵检测系统，打补丁等等。因为Linux也和其他的商用UNIX一样，不断有各类的安全漏洞被发现。我们对付这些漏洞不得不花很多的人力来堵住它。在这些手段之中，提高OS系统自身的牢固性就显得非常的重要。<br />2.1传统的Linux OS的不足之处<br />虽然Linux 比起 Windows 来说，它的可靠性，稳定定要好得多，但是他也是和其他的UNIX 一样，有以下这些不足之处。<br />１)存在特权用户root<br />　　任何人只要得到root的权限，对于整个系统都可以为所欲为。这一点Windows也一样。<br />２)对于文件的访问权的划分不够细<br />　　在linux系统里，对于文件的操作，只有「所有者」,「所有组」,「其他」这３类的划分。<br />　　对于「其他」这一类里的用户再细细的划分的话就没有办法了。<br />３)SUID程序的权限升级<br />　　如果设置了SUID权限的程序有了漏洞的话，很容易被攻击者所利用。<br />４)ＤＡＣ(Discretionary Access Control)问题<br />　　文件目录的所有者可以对文件进行所有的操作，这给系统整体的管理带来不便。<br /><br />对于以上这些的不足，防火墙，入侵检测系统都是无能为力的。<br />在这种背景下，对于访问权限大幅强化的OS SELinux来说，它的魅力的无穷的。<br />2.2 SELinux的优点<br />SELinux系统比起通常的Linux系统来，安全性能要高的多，它通过对于用户，进程权限的最小化，即使受到攻击，进程或者用户权限被夺去，也不会对整个系统造成重大影响。<br /><br />接下来我来介绍SELinux的一些特点。<br /><br />特点1：MAC(Mandatory Access Control)―――对访问的控制彻底化<br />对于所有的文件，目录，端口这类的资源的访问，都可以是基于策略设定的，这些策略是由管理员定制的、一般用户是没有权限更改的。<br /><br />特点2： TE （Type Enforcement）――― 对于进程只付与最小的权限<br />Te概念在 SELinux里非常的重要。它的特点是对所有的文件都赋予一个叫type的文件类型标签，对于所有的进程也赋予各自的一个叫 domain的 标签。Domain标签能够执行的操作也是由access vector在策略里定好的。<br />我们熟悉的apache服务器，httpd进程只能在httpd_t 里运行，这个httpd_t 的domain能执行的操作，比如能读网页内容文件赋予httpd_sys_content_t, 密码文件赋予shadow_t, TCP的80端口赋予 http_port_t等等。如果在access vector里我们不允许 http_t来对http_port_t进行操作的花，Apache启动都启动不了。反过来说，我们只允许80端口，只允许读取被标为 httpd_sys_content_t的文件，httpd_t就不能用别的端口，也不能更改那些被标为httpd_sys_content_t的文件（read only)。<br /><br />特点3： ｄｏｍａｉｎ迁移 ―― 防止权限升级<br />在用户环境里运行点对点下载软件azureus，你当前的domain是fu_t, 但是，你考虑到安全问题，你打算让他在azureus_t里运行，你要是在terminal里用命令启动azureus的话，它的进程的domain就会默认继承你实行的shell的fu_t。<br />有了ｄｏｍａｉｎ迁移的话，我们就可以让azureus在我们指定的azureus_t里运行，在安全上面，这种做法更可取，它不会影响到你的fu_t。<br />下面是domain迁移指示的例子：<br />domain_auto_trans(fu_t, azureus_exec_t, azureus_t)<br />意思就是，当在 fu_t domain里，实行了 被标为 azureus_exec_t的文件时，domain 从fu_t迁移到 azureus_t 。下面是Apache启动的迁移图。注意了，因为从哪一个domain能迁移到httpd_t是在策略里定好了，所以要是我们手动 (/etc/init.d/httpd start)启动apache的话，可能仍然留在sysadm_t里，这样就不能完成正确的迁移。要用run_init命令来手动启动。<br /><br />特点4： RBAC（role base access control) ――――― 对于用户只付与最小的权限<br />对于用户来说，被划分成一些ROLE，即使是ROOT用户，你要是不在sysadm_r里，也还是不能实行sysadm_t管理操作的。因为，那些ROLE可以执行那些domain也是在策略里设定的。ROLE也是可以迁移的，但是也只能安策略规定的迁移。<br /><br />3. 控制切换<br />从fedora core 2开始， 2.6内核的版本都支持selinux.我们看看 Fedora core 5 里的/etc/sysconfig/selinux标准设定吧。<br /># This file controls the state of SELinux on the system.<br /># SELINUX= can take one of these three values:<br /># enforcing - SELinux security policy is enforced.<br /># permissive - SELinux prints warnings instead of enforcing.<br /># disabled - SELinux is fully disabled.<br />SELINUX=enforcing<br />#SELINUX=disabled<br /># SELINUXTYPE= type of policy in use. Possible values are:<br /># targeted - Only targeted network daemons are protected.<br /># strict - Full SELinux protection.<br />SELINUXTYPE=targeted<br /><br />SELINUX有「disabled」「permissive」，「enforcing」3种选择。<br /><br />Disabled就不用说了，permissive就是Selinux有效，但是即使你违反了策略的话它让你继续操作，但是把你的违反的内容记录下来。在我们开发策略的时候非常的有用。<br />相当于Debug模式。<br />Enforcing就是你违反了策略，你就无法继续操作下去。<br /><br />SELINUXTYPE呢，现在主要有2大类，一类就是红帽子开发的targeted，它只是对于，主要的网络服务进行保护，比如 apache ,sendmail, bind,postgresql等，不属于那些domain的就都让他们在unconfined_t里，可导入性高，可用性好但是不能对整体进行保护。<br />另一类是Strict，是NAS开发的，能对整个系统进行保护，但是设定复杂，我认为虽然它复杂，但是一些基本的会了，还是可以玩得动的。<br /><br />我们除了在/etc/sysconfig/selinux设它有效无效外，在启动的时候，也可以通过传递参数selinux给内核来控制它。]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.guende.com/default.asp?id=429" /> 
	  <id>http://www.guende.com/default.asp?id=429</id> 
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[构建 MySQL 数据库服务器]]></title>
	  <author>
		 <name>guende</name>
		 <uri>http://www.guende.com/</uri>
		 <email>guende@126.com</email>
	  </author>
	  <category term="" scheme="http://www.guende.com/default.asp?cateID=21" label="系统┊操作系统相关" /> 
	  <updated>2008-05-20T08:29:24+08:00</updated>
	  <published>2008-05-20T08:29:24+08:00</published>
		  <summary type="html"><![CDATA[<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　在提到网站构架的时候，我们经常能够看到&ldquo;LAMP&rdquo;的说法，它就是&ldquo;Linux + Apache + MySQL + PHP&rdquo;。 MySQL+PHP的协同成功案例已经很多了。比如国外的PHPBB，VBB，国内的Discuz!论坛等等程序，都是用PHP + MySQL实现的。和那些商务专用数据库比起来，MySQL的功能和规模可能被好多人说的逊色一些，但对于我们个人来说，它的功能已经算是完备。而且，通 过Discuz!官方论坛上同时在线人数的数目，也可以证明MySQL的稳定性。</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"></span></font><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　这里，介绍一下</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">CentOS</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">下</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">数据库服务器的构建方法。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table style="WIDTH: 100%; mso-cellspacing: 1.5pt; mso-padding-alt: 0cm 0cm 0cm 0cm" cellpadding="0" width="100%" border="0" class="MsoNormalTable">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: #4665a6; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <table style="mso-cellspacing: 1.5pt" cellpadding="0" border="0" class="MsoNormalTable">
                <tbody>
                    <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
                        <td style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 0.75pt; BORDER-TOP: #ffffff; PADDING-LEFT: 0.75pt; BACKGROUND: #333333; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #ffffff; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #ffffff">
                        <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><b><span style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">安装</span></b><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span></b><b><span style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">及相关组件</span></b><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
                        <p>&nbsp;</p>
                        </span></b></p>
                        </td>
                    </tr>
                </tbody>
            </table>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　首先，安装</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]#</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">yum -y install mysql-server</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">安装</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">中间过程略.....</span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Complete!</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　然后，安装</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">PHP</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">访问</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">数据库的工具</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">&ldquo;php-mysql&rdquo;</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]#</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">yum -y install php-mysql</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">安装</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">php-mysql</span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt"></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><font color="#ffffff">中间过程略 。。。</font>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Complete! </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p><font size="3">&nbsp;</font></p>
</span></p>
<table style="WIDTH: 100%; mso-cellspacing: 1.5pt; mso-padding-alt: 0cm 0cm 0cm 0cm" cellpadding="0" width="100%" border="0" class="MsoNormalTable">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: #4665a6; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <table style="mso-cellspacing: 1.5pt" cellpadding="0" border="0" class="MsoNormalTable">
                <tbody>
                    <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
                        <td style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 0.75pt; BORDER-TOP: #ffffff; PADDING-LEFT: 0.75pt; BACKGROUND: #333333; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #ffffff; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #ffffff">
                        <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><b><span style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">配置</span></b><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL
                        <p>&nbsp;</p>
                        </span></b></p>
                        </td>
                    </tr>
                </tbody>
            </table>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　然后，配置</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]#</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">vi /etc/my.cnf</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">编辑</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">的配置文件</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[mysqld]<br />datadir=/var/lib/mysql<br />socket=/var/lib/mysql/mysql.sock<br /># Default to using old password format for compatibility with mysql 3.x<br /># clients (those using the mysqlclient10 compatibility package).<br />old_passwords=1</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">找到这一行，在这一行的下面添加新的规则，让</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">的默认编码为</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">UTF-8</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: lime; FONT-FAMILY: Arial; mso-font-kerning: 0pt">default-character-set = utf8</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">添加这一行</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br /></span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">然后在配置文件的文尾填加如下语句：</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: lime; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[mysql]<br />default-character-set = utf8</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p><font size="3">&nbsp;</font></p>
</span></p>
<table style="WIDTH: 100%; mso-cellspacing: 1.5pt; mso-padding-alt: 0cm 0cm 0cm 0cm" cellpadding="0" width="100%" border="0" class="MsoNormalTable">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: #4665a6; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <table style="mso-cellspacing: 1.5pt" cellpadding="0" border="0" class="MsoNormalTable">
                <tbody>
                    <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
                        <td style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 0.75pt; BORDER-TOP: #ffffff; PADDING-LEFT: 0.75pt; BACKGROUND: #333333; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #ffffff; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #ffffff">
                        <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><b><span style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">启动</span></b><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span></b><b><span style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">服务</span></b><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
                        <p>&nbsp;</p>
                        </span></b></p>
                        </td>
                    </tr>
                </tbody>
            </table>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　启动</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">，并让</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在系统重新启动后随系统自动启动。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">chkconfig mysqld on</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">设置</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">服务随系统启动自启动</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />[root@sample ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">chkconfig --list mysqld</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">确认</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">自启动</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />mysqld 0:off 1:off </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: fuchsia; FONT-FAMILY: Arial; mso-font-kerning: 0pt">2:on 3:on 4:on 5:on</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> 6:off</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">如果</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">2--5</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">为</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">on</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">的状态就</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">OK</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />[root@sample ~]#</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">/etc/rc.d/init.d/mysqld start</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">启动</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">服务</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Initializing MySQL database:</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> [ </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: lime; FONT-FAMILY: Arial; mso-font-kerning: 0pt">OK</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> ]<br />Starting MySQL: </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[ </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: lime; FONT-FAMILY: Arial; mso-font-kerning: 0pt">OK</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> ]</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p><font size="3">&nbsp;</font></p>
</span></p>
<table style="WIDTH: 100%; mso-cellspacing: 1.5pt; mso-padding-alt: 0cm 0cm 0cm 0cm" cellpadding="0" width="100%" border="0" class="MsoNormalTable">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: #4665a6; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <table style="mso-cellspacing: 1.5pt" cellpadding="0" border="0" class="MsoNormalTable">
                <tbody>
                    <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
                        <td style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 0.75pt; BORDER-TOP: #ffffff; PADDING-LEFT: 0.75pt; BACKGROUND: #333333; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #ffffff; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #ffffff">
                        <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span></b><b><span style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">初始环境设定</span></b><b><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: white; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
                        <p>&nbsp;</p>
                        </span></b></p>
                        </td>
                    </tr>
                </tbody>
            </table>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /><font size="3">[1]</font></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">为</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">的</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">root</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">用户设置密码</span></font><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在刚刚被安装的时候，它的</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">root</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">用户是没有被设置密码的。首先来设置</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">的</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">root</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]#</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql -u root</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">用</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">用户登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">服务器</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Welcome to the MySQL monitor. Commands end with ; or \g.<br />Your MySQL connection id is 2 to server version: <chsdate w:st="on" year="1899" month="12" day="30" islunardate="False" isrocdate="False">4.1.20</chsdate> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">select user,host,password from mysql.user;</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">查看用户信息</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">+------+------------------------------+---------------+<br />| user | host </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| password</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />+------+------------------------------+---------------+<br />| root | localhost</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　&nbsp; </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码为空</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> <br />| root | localhost.localdomain</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&nbsp;&nbsp; |</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> |</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码为空</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />|</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|&nbsp;localhost.localdomain&nbsp;&nbsp; &nbsp;| </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />|</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| localhost</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> | </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />+------+------------------------------+---------------+</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">4 rows in set (0.00 sec)</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">set password for root@localhost=password('</span><span style="FONT-SIZE: 12pt; COLOR: fuchsia; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在这里填入</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: fuchsia; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: fuchsia; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">');</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">设置</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Query OK, 0 rows affected (0.01 sec)</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">set password for <a href="http://www.guende.com/mailto:root@'localhost.localdomain'=password('">root@'localhost.localdomain'=password('</a></span><span style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在这里填入</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">');</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">设置</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Query OK, 0 rows affected (0.01 sec)</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">select user,host,password from mysql.user;</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">查看用户信息</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">+------+--------------------------------+--------------------------+<br />| user | host</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| password</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />+------+--------------------------------+--------------------------+<br />| root | localhost</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: fuchsia; FONT-FAMILY: Arial; mso-font-kerning: 0pt">19b68057189b<chmetcnv w:st="on" unitname="F" sourcevalue="27" hasspace="False" negative="False" numbertype="1" tcsc="0">027f</chmetcnv></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> |</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码被设置</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />| root | localhost.localdomain&nbsp;&nbsp;&nbsp;&nbsp;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: fuchsia; FONT-FAMILY: Arial; mso-font-kerning: 0pt">19b68057189b<chmetcnv w:st="on" unitname="F" sourcevalue="27" hasspace="False" negative="False" numbertype="1" tcsc="0">027f</chmetcnv></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> |</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码被设置</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />| </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> | localhost.localdomain&nbsp;&nbsp;&nbsp;&nbsp;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />| </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> | localhost</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> |<br />+------+--------------------------------+--------------------------+<br />4 rows in set (0.01 sec)</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">exit</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">退出</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">服务器</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Bye</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"> </span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　然后，测试一下</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">root</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">密码有没有生效。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql -u root</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">通过空密码用</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">出现此错误信息说明密码设置成功</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />[root@localhost ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql -u root -h sample.centospub.com</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> &larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">通过空密码用</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">出现此错误信息说明密码设置成功</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />[root@sample ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql -u root -p</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">通过密码用</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Enter password:</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在这里输入密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />Welcome to the MySQL monitor. Commands end with ; or \g.</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">确认用密码能够成功登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Your MySQL connection id is 5 to server version: <chsdate w:st="on" year="1899" month="12" day="30" islunardate="False" isrocdate="False">4.1.20</chsdate> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt; </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">exit</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Bye<br /><br />[root@sample ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql -u root -h <font color="#cccccc">localhost.localdomain&nbsp;&nbsp;</font>-p</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">通过密码用</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Enter password:</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在这里输入密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />Welcome to the MySQL monitor. Commands end with ; or \g.</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">确认用密码能够成功登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Your MySQL connection id is 6 to server version: <chsdate w:st="on" year="1899" month="12" day="30" islunardate="False" isrocdate="False">4.1.20</chsdate>
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt; </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">exit</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">退出</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">MySQL</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">服务器</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Bye</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            </td>
        </tr>
    </tbody>
</table>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 12pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /><font size="3">[2] </font></span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"><font size="3">删除匿名用户</font></span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt"><br /><br /></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　在</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">MySQL</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">刚刚被安装后，存在用户名、密码为空的用户。这使得数据库服务器有无需密码被登录的可能性。为消除隐患，将匿名用户删除。</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt; mso-bidi-font-size: 10.5pt">
<p>&nbsp;</p>
</span></font></p>
<table class="MsoNormalTable" style="BORDER-RIGHT: 1.5pt outset; BORDER-TOP: 1.5pt outset; BORDER-LEFT: 1.5pt outset; WIDTH: 100%; BORDER-BOTTOM: 1.5pt outset; mso-cellspacing: 1.5pt" cellpadding="0" width="100%" border="1">
    <tbody>
        <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
            <td style="BORDER-RIGHT: #d4d0c8; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; BACKGROUND: black; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: #d4d0c8">
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">[root@sample ~]# </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql -u root -p</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">通过密码用</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">root</span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">登录</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Enter password:</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">在这里输入密码</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br /><br />Welcome to the MySQL monitor. Commands end with ; or \g.<br />Your MySQL connection id is 7 to server version: <chsdate w:st="on" year="1899" month="12" day="30" islunardate="False" isrocdate="False">4.1.20</chsdate> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial; mso-font-kerning: 0pt">
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt; </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">select user,host from mysql.user;</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">查看用户信息</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />+------+----------------------------+<br />| user | host</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> |<br />+------+----------------------------+<br />|</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| localhost </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />| root | localhost </span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />|</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">| localhost.localdomain&nbsp;&nbsp;&nbsp;&nbsp;|<br />| root | localhost.localdomain&nbsp;&nbsp;&nbsp;&nbsp;</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">|<br />+------+----------------------------+<br />4 rows in set (0.02 sec)
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt; </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">delete from mysql.user where user='';</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">删除匿名用户</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />Query OK, 2 rows affected (0.17 sec)
            <p>&nbsp;</p>
            </span></p>
            <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto" align="left"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt">mysql&gt; </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: yellow; FONT-FAMILY: Arial; mso-font-kerning: 0pt">select user,host from mysql.user;</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> </span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: Arial; mso-font-kerning: 0pt">&larr; </span><span style="FONT-SIZE: 12pt; COLOR: #0099ff; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">查看用户信息</span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: Arial; mso-font-kerning: 0pt"><br />+------+----------------------------+<br />| user | host</span><span style="FONT-SIZE: 12pt; COLOR: #cccccc; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial">　　　　　　　　