CentOS 7 安装 MySQL 5.6遇到的各种问题小结
<p>在一测试服务器（CentOS Linux release 7.2.1511）上安装MySQL 5.6（5.6.19 MySQL Community Server）时遇到下面错误，这个是因为CentOS 7的默认数据库已经不再是MySQL了，而是MariaDB. MySQL安装时的mysql lib库与mariadb的库、包冲突了，如下详情所示（省略了大量日志）</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_408401">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -ivh MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpm </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Preparing... </code><code class="bash comments">################################# </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/czech/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/danish/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/dutch/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/english/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/estonian/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/french/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/german/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/greek/errmsg</code><code class="bash plain">.sys from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">........................................................................................................................................................................</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/charsets/macroman</code><code class="bash plain">.xml from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash functions">file</code> <code class="bash plain">/usr/share/mysql/charsets/swe7</code><code class="bash plain">.xml from </code><code class="bash functions">install</code> <code class="bash plain">of MySQL-server-advanced-5.6.20-1.rhel5.x86_64 conflicts with </code><code class="bash functions">file</code> <code class="bash plain">from package mariadb-libs-1:5.5.50-1.el7_2.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>
检查是否存在mariadb的相关组件,然后删除mariadb相关组件。如下所示：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_611746">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># more /etc/redhat-release </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">CentOS Linux release 7.2.1511 (Core) </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -qa |grep mariadb</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">mariadb-libs-5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -e mariadb-libs-5.5.50-1.el7_2.x86_64</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">error: Failed dependencies:</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -e mariadb-libs-5.5.50-1.el7_2.x86_64 --nodeps</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
当然此处删除mariadb-libs-5.5.50-1.el7_2.x86_64组件时遇到依赖错误，遂强制删除该组件，最好使用yum删除mariadb相关组件。然后重新安装MySQL时遇到"error: MySQL-server-advanced-5.6.20-1.rhel5.x86_64: install failed"错误，如下所示：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_531690">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># cd /tmp</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments"># ls</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">hsperfdata_azrlnx06 jirasetup MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpm</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain"></code><code class="bash comments"># rpm -ivh MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpm </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">Preparing... </code><code class="bash comments">################################# </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">Updating / installing...</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">1:MySQL-server-advanced-5.6.20-1.rh</code><code class="bash comments">################################# </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">error: unpacking of archive failed on </code><code class="bash functions">file</code> <code class="bash plain">/usr/bin/innochecksum</code><code class="bash plain">;582535c8: cpio: </code><code class="bash functions">read</code> <code class="bash plain">failed - No such </code><code class="bash functions">file</code> <code class="bash plain">or directory</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">error: MySQL-server-advanced-5.6.20-1.rhel5.x86_64: </code><code class="bash functions">install</code> <code class="bash plain">failed</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain"></code><code class="bash comments"># </code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">clip_image001</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<img style="max-width:100%!important;height:auto!important;"title="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" alt="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" src="https://zhuji.jb51.net/uploads/img/202305/64a5d8f07c9bbd6b29c51a461b6de295.jpg"></p>
<p>
对这个错误有点莫名其妙，卸载MySQL相关组件后，重新安装MySQL，发现缺少Perl相关模组。如下所示：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_419920">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -ivh MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpm </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Preparing... </code><code class="bash comments">################################# </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">Updating / installing...</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">1:MySQL-server-advanced-5.6.20-1.rh</code><code class="bash comments">################################# </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">FATAL ERROR: please </code><code class="bash functions">install</code> <code class="bash plain">the following Perl modules before executing </code><code class="bash plain">/usr/bin/mysql_install_db</code><code class="bash plain">:</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">Data::Dumper</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
使用yum安装了 perl perl-devel相关包（注意：此处安装MySQL时，没有输出安装相关Detail的信息，是因为Perl相关模组没有安装的缘故，此处还漏掉了安装perl-Data-Dumper）</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_674305">
<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"></code><code class="bash comments"># yum install -y perl perl-devel</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
安装完Perl相关组件后，重新安装MySQL，如下所示，安装成功，但是没有输出安装相关Detail的信息（因为没有安装perl-Data-Dumper），启动MySQL报错</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_489125">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">root@azrlnx06 jirasetup]</code><code class="bash comments"># rpm -ivh MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpm </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Preparing... </code><code class="bash comments">################################# </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">Updating / installing...</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">1:MySQL-server-advanced-5.6.20-1.rh</code><code class="bash comments">################################# </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -ivh MySQL-client-advanced-5.6.20-1.rhel5.x86_64.rpm </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">Preparing... </code><code class="bash comments">################################# </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">Updating / installing...</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">1:MySQL-client-advanced-5.6.20-1.rh</code><code class="bash comments">################################# </code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain"></code><code class="bash comments"># service mysql start</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">Starting MySQL............. ERROR! The server quit without updating PID </code><code class="bash functions">file</code> <code class="bash plain">(</code><code class="bash plain">/var/lib/mysql/azrlnx06</code><code class="bash plain">.pid).</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain"></code><code class="bash comments">#</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的错误日志，然后检查/var/lib/mysql/azrlnx06.err错误日志，发现如下错误信息：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_122888">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
<div class="line number37 index36 alt2">
37</div>
<div class="line number38 index37 alt1">
38</div>
<div class="line number39 index38 alt2">
39</div>
<div class="line number40 index39 alt1">
40</div>
<div class="line number41 index40 alt2">
41</div>
<div class="line number42 index41 alt1">
42</div>
<div class="line number43 index42 alt2">
43</div>
<div class="line number44 index43 alt1">
44</div>
<div class="line number45 index44 alt2">
45</div>
<div class="line number46 index45 alt1">
46</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># find / -name *.err</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">/var/lib/mysql/azrlnx06</code><code class="bash plain">.err</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">/var/log/azure/Microsoft</code><code class="bash plain">.OSTCExtensions.LinuxDiagnostic</code><code class="bash plain">/2</code><code class="bash plain">.3.9011</code><code class="bash plain">/mdsd</code><code class="bash plain">.err</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">/var/log/azure/Microsoft</code><code class="bash plain">.OSTCExtensions.LinuxDiagnostic</code><code class="bash plain">/2</code><code class="bash plain">.3.9013</code><code class="bash plain">/mdsd</code><code class="bash plain">.err</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">/var/log/mdsd/mdsd</code><code class="bash plain">.err</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain"></code><code class="bash comments"># more /var/lib/mysql/azrlnx06.err</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">161111 03:28:25 mysqld_safe Starting mysqld daemon with databases from </code><code class="bash plain">/var/lib/mysql</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">2016-11-11 03:28:25 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation </code><code class="bash keyword">for</code> <code class="bash functions">more</code> <code class="bash plain">details).</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 Plugin </code><code class="bash string">'FEDERATED'</code> <code class="bash plain">is disabled.</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">/usr/sbin/mysqld</code><code class="bash plain">: Table </code><code class="bash string">'mysql.plugin'</code> <code class="bash plain">doesn't exist</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 Can't </code><code class="bash functions">open</code> <code class="bash plain">the mysql.plugin table. Please run mysql_upgrade to create it.</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Using atomics to ref count buffer pool pages</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: The InnoDB memory heap is disabled</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Mutexes and rw_locks use GCC atomic builtins</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Memory barrier is not used</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Compressed tables use zlib 1.2.3</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Using Linux native AIO</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Using CPU crc32 instructions</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Initializing buffer pool, size = 128.0M</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Completed initialization of buffer pool</code>
</div>
<div class="line number21 index20 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: The first specified data </code><code class="bash functions">file</code> <code class="bash plain">.</code><code class="bash plain">/ibdata1</code> <code class="bash plain">did not exist: a new database to be created!</code>
</div>
<div class="line number22 index21 alt1">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Setting </code><code class="bash functions">file</code> <code class="bash plain">.</code><code class="bash plain">/ibdata1</code> <code class="bash plain">size to 12 MB</code>
</div>
<div class="line number23 index22 alt2">
<code class="bash plain">2016-11-11 03:28:25 2144 InnoDB: Database physically writes the </code><code class="bash functions">file</code> <code class="bash plain">full: wait...</code>
</div>
<div class="line number24 index23 alt1">
<code class="bash plain">2016-11-11 03:28:26 2144 InnoDB: Setting log </code><code class="bash functions">file</code> <code class="bash plain">.</code><code class="bash plain">/ib_logfile101</code> <code class="bash plain">size to 48 MB</code>
</div>
<div class="line number25 index24 alt2">
<code class="bash plain">2016-11-11 03:28:31 2144 InnoDB: Setting log </code><code class="bash functions">file</code> <code class="bash plain">.</code><code class="bash plain">/ib_logfile1</code> <code class="bash plain">size to 48 MB</code>
</div>
<div class="line number26 index25 alt1">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: Renaming log </code><code class="bash functions">file</code> <code class="bash plain">.</code><code class="bash plain">/ib_logfile101</code> <code class="bash plain">to .</code><code class="bash plain">/ib_logfile0</code>
</div>
<div class="line number27 index26 alt2">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: New log files created, LSN=45781</code>
</div>
<div class="line number28 index27 alt1">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: Doublewrite buffer not found: creating new</code>
</div>
<div class="line number29 index28 alt2">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: Doublewrite buffer created</code>
</div>
<div class="line number30 index29 alt1">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: 128 rollback segment(s) are active.</code>
</div>
<div class="line number31 index30 alt2">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: Creating foreign key constraint system tables.</code>
</div>
<div class="line number32 index31 alt1">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: Foreign key constraint system tables created</code>
</div>
<div class="line number33 index32 alt2">
<code class="bash plain">2016-11-11 03:28:37 2144 InnoDB: Creating tablespace and datafile system tables.</code>
</div>
<div class="line number34 index33 alt1">
<code class="bash plain">2016-11-11 03:28:38 2144 InnoDB: Tablespace and datafile system tables created.</code>
</div>
<div class="line number35 index34 alt2">
<code class="bash plain">2016-11-11 03:28:38 2144 InnoDB: Waiting </code><code class="bash keyword">for</code> <code class="bash plain">purge to start</code>
</div>
<div class="line number36 index35 alt1">
<code class="bash plain">2016-11-11 03:28:38 2144 InnoDB: 5.6.20 started; log sequence number 0</code>
</div>
<div class="line number37 index36 alt2">
<code class="bash plain">2016-11-11 03:28:38 2144 No existing UUID has been found, so we assume that this is the first </code><code class="bash functions">time</code> <code class="bash plain">that this server has been started. Generating a new UUID: ef3b0cd5-a7be-11e6-98b3-000d3a8062fe.</code>
</div>
<div class="line number38 index37 alt1">
<code class="bash plain">2016-11-11 03:28:38 2144 RSA private key </code><code class="bash functions">file</code> <code class="bash plain">not found: </code><code class="bash plain">/var/lib/mysql//private_key</code><code class="bash plain">.pem. Some authentication plugins will not work.</code>
</div>
<div class="line number39 index38 alt2">
<code class="bash plain">2016-11-11 03:28:38 2144 RSA public key </code><code class="bash functions">file</code> <code class="bash plain">not found: </code><code class="bash plain">/var/lib/mysql//public_key</code><code class="bash plain">.pem. Some authentication plugins will not work.</code>
</div>
<div class="line number40 index39 alt1">
<code class="bash plain">2016-11-11 03:28:38 2144 Server </code><code class="bash functions">hostname</code> <code class="bash plain">(bind-address): </code><code class="bash string">'*'</code><code class="bash plain">; port: 3306</code>
</div>
<div class="line number41 index40 alt2">
<code class="bash plain">2016-11-11 03:28:38 2144 IPv6 is available.</code>
</div>
<div class="line number42 index41 alt1">
<code class="bash plain">2016-11-11 03:28:38 2144 - </code><code class="bash string">'::'</code> <code class="bash plain">resolves to </code><code class="bash string">'::'</code><code class="bash plain">;</code>
</div>
<div class="line number43 index42 alt2">
<code class="bash plain">2016-11-11 03:28:38 2144 Server socket created on IP: </code><code class="bash string">'::'</code><code class="bash plain">.</code>
</div>
<div class="line number44 index43 alt1">
<code class="bash plain">2016-11-11 03:28:38 2144 Fatal error: Can</code><code class="bash string">'t open and lock privilege tables: Table '</code><code class="bash plain">mysql.user</code><code class="bash string">' doesn'</code><code class="bash plain">t exist</code>
</div>
<div class="line number45 index44 alt2">
<code class="bash plain">161111 03:28:38 mysqld_safe mysqld from pid </code><code class="bash functions">file</code> <code class="bash plain">/var/lib/mysql/azrlnx06</code><code class="bash plain">.pid ended</code>
</div>
<div class="line number46 index45 alt1">
<code class="bash plain">clip_image002</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<img style="max-width:100%!important;height:auto!important;"title="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" alt="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" src="https://zhuji.jb51.net/uploads/img/202305/c28c1557b0e78db9504d795f1e9bd427.jpg"></p>
<p>
搜索了一些相关资料，应该是perl-Data-Dumper模组没有安装，导致安装过程中，初始化数据库失败，所以启动MySQL服务时，找不到相关系统表。具体参考官方文档MySQL-server RPM does not install perl-Data-Dumper as a dependency</p>
<p>
<strong>Description:</strong></p>
<p>
MySQL-server requires perl-Data-Dumper to function. However, perl-Data-Dumper is not listed by the MySQL-server RPM as a dependency. So if a linux server does not have perl-Data-Dumper installed, the install-mysql-db will fail. And because of missing the initial database, the mysql service could not be started.</p>
<p>
<strong>How to repeat:</strong></p>
<p>
On a linux server, make sure there is no perl-Data-Dumper installed. Install MySQL-server using yum. There should be error message complaining database could not be created.</p>
<p>
<strong>Suggested fix:</strong></p>
<p>
Add perl-Data-Dumper as a dependency of the RPM package</p>
<p>
<span><strong>解决方法：</strong></span></p>
<p>
<strong>1：安装perl-Data-Dumper模组。</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_4665">
<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"></code><code class="bash comments"># yum install -y perl-Data-Dumper</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>2：初始化数据库</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_588927">
<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"></code><code class="bash comments"># sudo mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">clip_image003</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<br><div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<img style="max-width:100%!important;height:auto!important;"title="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" alt="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" src="https://zhuji.jb51.net/uploads/img/202305/389bd8063610243c0399df161386f06e.jpg"></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_208337">
<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>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># service mysql start</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Starting MySQL. SUCCESS! </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># /usr//bin/mysqladmin -u root password 'Qwe!23'</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">Warning: Using a password on the </code><code class="bash functions">command</code> <code class="bash plain">line interface can be insecure.</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，然后重新安装，就能看到安装过程输出的Detail信息输出了。</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" alt="CentOS 7 安装 MySQL 5.6遇到的各种问题小结" src="https://zhuji.jb51.net/uploads/img/202305/b5381aba444555dcd6fdd266f827219c.jpg"></p>
<p>
以上所述是小编给大家介绍的CentOS 7 安装 MySQL 5.6遇到的各种冲突问题，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！</p>
<p>
</p>
頁:
[1]