在CentOS 7下使用yum配置MySQL源并安装MySQL
<p>CentOS7默认数据库是mariadb,配置等用着不习惯,因此决定改成mysql,但是CentOS7的yum源中默认好像是没有mysql的。为了解决这个问题，我们要先下载mysql的repo源。</p>
<p>
1.由于CentOS 的yum源中没有mysql，需要到mysql的官网下载yum repo配置文件。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_449429">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">wget http:</code><code class="bash plain">//dev</code><code class="bash plain">.mysql.com</code><code class="bash plain">/get/mysql57-community-release-el7-9</code><code class="bash plain">.noarch.rpm</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
2.安装yum repo文件</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_286637">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">rpm -ivh mysql57-community-release-el7-9.noarch.rpm</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo mysql-community-source.repo</p>
<p>
3.然后更新yum缓存</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_497299">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">yum clean all</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">yum makecache</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
4.安装mysql</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_260904">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">yum </code><code class="bash functions">install</code> <code class="bash plain">mysql-community-client.x86_64 mysql-community-common.x86_64 mysql-community-devel.x86_64 mysql-community-libs.x86_64 mysql-community-server.x86_64</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
或者</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_711661">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">rpm </code><code class="bash functions">install</code> <code class="bash plain">mysql-server</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
5.启动mysql</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_512771">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">service mysqld start</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
6.查看初始密码</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_133354">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">grep</code> <code class="bash string">'temporary password'</code> <code class="bash plain">/var/log/mysqld</code><code class="bash plain">.log</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
得到如下内容：</p>
<p>
2016-10-28T10:36:32.369073Z 1 A temporary password is generated for root@localhost: 5Oazqgpiat!p</p>
<p>
7.使用初始密码登录</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_322327">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mysql -u root -p </code><code class="bash plain">//</code><code class="bash plain">回车，然后输入上一步查到的初始密码</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
8.更改初始密码</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_34086">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">ALTER USER </code><code class="bash string">'root'</code><code class="bash plain">@</code><code class="bash string">'localhost'</code> <code class="bash plain">IDENTIFIED BY </code><code class="bash string">'MyNewPass4!'</code><code class="bash plain">;</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">//</code><code class="bash plain">现在的mysql对密码强度要求较高，需要包含大小写字母、数字和特殊字符</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
至此，mysql-server安装完成</p>
頁:
[1]