<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[静怡家园]]></title> 
<link>http://www.zhanghaijun.com/index.php</link> 
<description><![CDATA[书山有路勤为径，学海无涯苦作舟！]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[静怡家园]]></copyright>
<item>
<link>http://www.zhanghaijun.com/post//</link>
<title><![CDATA[CentOS/RedHat Enterprise使用官方源安装MySQL]]></title> 
<author>碟舞飞扬 &lt;webmaster@zhanghaijun.com&gt;</author>
<category><![CDATA[数据库类]]></category>
<pubDate>Wed, 18 Jan 2017 03:54:10 +0000</pubDate> 
<guid>http://www.zhanghaijun.com/post//</guid> 
<description>
<![CDATA[ 
	一、RPM包下载地址：<br/><a href="http://dev.mysql.com/downloads/repo/yum/" target="_blank">http://dev.mysql.com/downloads/repo/yum/</a><br/><br/>请根据自己的操作系统，选择要下载的rpm包：<br/>Red Hat Enterprise Linux 7/CentOS 7<br/>mysql57-community-release-el7-9.noarch.rpm<br/>Red Hat Enterprise Linux 6/CentOS 6<br/>mysql57-community-release-el6-9.noarch.rpm<br/>Red Hat Enterprise Linux 5/CentOS 5<br/>mysql57-community-release-el5-7.noarch.rpm<br/><br/>以CentOS 6为例：<br/><div class="code">wget https://repo.mysql.com//mysql57-community-release-el6-9.noarch.rpm</div><br/><br/>二、安装：<br/><textarea name="code" class="c" rows="15" cols="100">[root@localhost ~]# rpm -Uvh mysql57-community-release-el6-9.noarch.rpm
warning: mysql57-community-release-el6-9.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;########################################### [100%]
&nbsp;&nbsp; 1:mysql57-community-relea########################################### [100%]</textarea><br/><br/>2.1、选择要安装的MySQL版本：<br/><textarea name="code" class="c" rows="15" cols="100">[root@localhost ~]# yum repolist all &#124; grep mysql
mysql-connectors-community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL Connectors Community&nbsp;&nbsp;&nbsp;&nbsp; enabled:&nbsp;&nbsp;&nbsp;&nbsp; 30
mysql-connectors-community-source MySQL Connectors Community - S disabled
mysql-tools-community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL Tools Community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;enabled:&nbsp;&nbsp;&nbsp;&nbsp; 42
mysql-tools-community-source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL Tools Community - Source disabled
mysql-tools-preview&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL Tools Preview&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;disabled
mysql-tools-preview-source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL Tools Preview - Source&nbsp;&nbsp; disabled
mysql55-community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL 5.5 Community Server&nbsp;&nbsp;&nbsp;&nbsp; disabled
mysql55-community-source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL 5.5 Community Server - S disabled
mysql56-community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL 5.6 Community Server&nbsp;&nbsp;&nbsp;&nbsp; disabled
mysql56-community-source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL 5.6 Community Server - S disabled
mysql57-community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL 5.7 Community Server&nbsp;&nbsp;&nbsp;&nbsp; enabled:&nbsp;&nbsp;&nbsp;&nbsp;164
mysql57-community-source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL 5.7 Community Server - S disabled
mysql80-community&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL 8.0 Community Server&nbsp;&nbsp;&nbsp;&nbsp; disabled
mysql80-community-source&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MySQL 8.0 Community Server - S disabled</textarea><br/><br/>2.2、安装MySQL，默认安装的版本是5.7，所以不需要做任何的修改。<br/><textarea name="code" class="c" rows="15" cols="100">yum -y install mysql-community-server</textarea><br/><br/>2.3、安装其他版本，假如你想安装MySQL5.6或者其他版本,需要修改 /etc/yum.repos.d/mysql-community.repo文件。<br/><textarea name="code" class="c" rows="15" cols="100">vi /etc/yum.repos.d/mysql-community.repo
将[mysql57-community]内的enabled=1修改为enabled=0
将[mysql56-community]内的enabled=0修改为enabled=1
保存并退出
然后再执行 yum -y install mysql-community-server 安装的版本就是MySQL5.6了，选择MySQL5.5或者MySQL8.0的方法一样，把要选择的版本的[mysqlXX-community]下面的enabled=0改为enabled=1，不需要的版本的[mysqlXX-community]下面的enabled=1改为enabled=0，然后再执行yum -y install mysql-community-server安装。</textarea><br/><br/>三、启动MySQL服务<br/><textarea name="code" class="c" rows="15" cols="100">service mysqld start</textarea><br/><br/>3.1、查看MySQL状态<br/><textarea name="code" class="c" rows="15" cols="100">service mysqld status</textarea><br/><br/>对于MySQL5.7版本，系统初始化之后会生成root账户的密码，保存在日志文件里，使用grep &#039;temporary password&#039; /var/log/mysqld.log 查看初始密码，MySQL5.7的密码要求至少包含一个大写字母，一个小写字母，一个数字和一个特殊字符，并且总密码长度至少为8个字符。<br/><br/>3.2、修改密码<br/><textarea name="code" class="c" rows="15" cols="100">mysql -uroot -p 
输入你上面查看到的初始密码
ALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;MyNewPass4!&#039;;
修改root@localhost账户的密码为MyNewPass4!</textarea><br/><br/>3.3、安装其他MySQL产品和组件<br/><textarea name="code" class="c" rows="15" cols="100">yum --disablerepo=&#92;* --enablerepo=&#039;mysql*-community*&#039; list available
yum install package-name&nbsp;&nbsp;#package-name 为你选择要安装的包名如：mysql-community-client</textarea><br/><br/>官方文档：<br/>https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/<br/>Tags - <a href="http://www.zhanghaijun.com/tags/mysql/" rel="tag">mysql</a> , <a href="http://www.zhanghaijun.com/tags/rpm/" rel="tag">rpm</a> , <a href="http://www.zhanghaijun.com/tags/yum/" rel="tag">yum</a> , <a href="http://www.zhanghaijun.com/tags/mysql5.5/" rel="tag">mysql5.5</a> , <a href="http://www.zhanghaijun.com/tags/mysql5.6/" rel="tag">mysql5.6</a> , <a href="http://www.zhanghaijun.com/tags/mysql5.7/" rel="tag">mysql5.7</a> , <a href="http://www.zhanghaijun.com/tags/mysql8.0/" rel="tag">mysql8.0</a>
]]>
</description>
</item><item>
<link>http://www.zhanghaijun.com/post//#blogcomment</link>
<title><![CDATA[[评论] CentOS/RedHat Enterprise使用官方源安装MySQL]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>http://www.zhanghaijun.com/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>