Centos7 安装 Mysql8教程
<p><strong>Mysql8新特性：</strong></p>
<p>
Mysql从5.x版本直接跳跃到8.x，我个人是这么看的：</p>
<blockquote>
<p>
MySQL 5.5 -> MySQL 5<br>
MySQL 5.6 -> MySQL 6<br>
MySQL 5.7 -> MySQL 7<br>
MySQL 8.0 -> MySQL 8</p>
</blockquote>
<p>
当然也有可能是Mysql6、7内部难产了-_-，自从被Oracle收购后，活力依旧在，mysql8有以下新特性：</p>
<ul>
<li>
MySQL 文档存储</li>
<li>
默认 utf8mb4 编码</li>
<li>
JSON 增强</li>
<li>
CTEs（译者注：Common Table Expresssions 公共表格表达式）</li>
<li>
窗口函数</li>
<li>
降序索引</li>
<li>
更好的优化器消费模型</li>
<li>
MySQL 服务器组件</li>
<li>
GIS（译者注：Geographic Information System 地理信息系统） 提升</li>
<li>
InnoDB 引擎的 NO WAIT 和 SKIP \ LOCKED 选项</li>
</ul>
<p>
<strong>Centos7 Mysql8安装步骤：</strong></p>
<p>
<strong>1、设置mysql源</strong></p>
<p>
首先，您需要在MySQL提供的系统中启用MySQL yum存储库。 根据您的操作系统版本执行以下命令之一，这里我们选择CentOS 7 / RHEL 7的源</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_100646">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments">###在CentOS 7 / RHEL 7系统上### </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">rpm -Uvh https:</code><code class="bash plain">//repo</code><code class="bash plain">.mysql.com</code><code class="bash plain">/mysql80-community-release-el7-3</code><code class="bash plain">.noarch.rpm</code>
</div>
<div class="line number3 index2 alt2">
</div>
<div class="line number4 index3 alt1">
<code class="bash comments">###在CentOS 7 / RHEL 6系统上### </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">rpm -Uvh https:</code><code class="bash plain">//repo</code><code class="bash plain">.mysql.com</code><code class="bash plain">/mysql80-community-release-el6-3</code><code class="bash plain">.noarch.rpm</code>
</div>
<div class="line number6 index5 alt1">
</div>
<div class="line number7 index6 alt2">
<code class="bash comments">###在Fedora 30系统上### </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">rpm -Uvh https:</code><code class="bash plain">//repo</code><code class="bash plain">.mysql.com</code><code class="bash plain">/mysql80-community-release-fc30-1</code><code class="bash plain">.noarch.rpm</code>
</div>
<div class="line number9 index8 alt2">
</div>
<div class="line number10 index9 alt1">
<code class="bash comments">###在Fedora 29系统上### </code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">rpm -Uvh https:</code><code class="bash plain">//repo</code><code class="bash plain">.mysql.com</code><code class="bash plain">/mysql80-community-release-fc29-2</code><code class="bash plain">.noarch.rpm</code>
</div>
<div class="line number12 index11 alt1">
</div>
<div class="line number13 index12 alt2">
<code class="bash comments">###在Fedora 28系统上### </code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">rpm -Uvh https:</code><code class="bash plain">//repo</code><code class="bash plain">.mysql.com</code><code class="bash plain">/mysql80-community-release-fc28-2</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>
<strong>2、安装MySQL Community Server</strong></p>
<p>
MySQL yum存储库包含用于多个MySQL版本的多个存储库配置。 因此，首先禁用mysql repo文件中的所有存储库</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_627653">
<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">sed</code> <code class="bash plain">-i </code><code class="bash string">'s/enabled=1/enabled=0/'</code> <code class="bash plain">/etc/yum</code><code class="bash plain">.repos.d</code><code class="bash plain">/mysql-community</code><code class="bash plain">.repo</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
启用centos mysql8版本</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_509837">
<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="sql plain">## CentOS & RedHat 版本</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">yum </code><code class="sql comments">--enablerepo=mysql80-community install mysql-community-server</code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">## Fedora Systems 版本</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">dnf </code><code class="sql comments">--enablerepo=mysql80-community install mysql-community-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>
<strong>3、启动MySQL服务</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_656114">
<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>
使用Systemd</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_402820">
<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">systemctl start mysqld.service</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>4、查找MySQL root密码</strong></p>
<p>
安装MySQL 8.0后，将为MySQL根用户创建一个临时密码。 您可以在日志文件中找到生成的临时密码。密码文件位置：/var/log/mysqld.log</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_265275">
<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">"A 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>
<strong>5、重置root密码</strong></p>
<p>
首次安装MySQL后，执行mysql_secure_installation命令以保护MySQL服务器，包含重置密码步骤</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_744950">
<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="sql plain">mysql_secure_installation</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_655486">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">Enter </code><code class="sql keyword">password</code> <code class="sql keyword">for</code> <code class="sql color2">user</code> <code class="sql plain">root:</code>
</div>
<div class="line number2 index1 alt1">
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">The existing </code><code class="sql keyword">password</code> <code class="sql keyword">for</code> <code class="sql plain">the </code><code class="sql color2">user</code> <code class="sql plain">account root has expired. Please </code><code class="sql keyword">set</code> <code class="sql plain">a new </code><code class="sql keyword">password</code><code class="sql plain">.</code>
</div>
<div class="line number4 index3 alt1">
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">New </code><code class="sql keyword">password</code><code class="sql plain">:</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">Re-enter new </code><code class="sql keyword">password</code><code class="sql plain">:</code>
</div>
<div class="line number7 index6 alt2">
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">Remove anonymous users? (Press y|Y </code><code class="sql keyword">for</code> <code class="sql plain">Yes, </code><code class="sql color1">any</code> <code class="sql plain">other </code><code class="sql keyword">key</code> <code class="sql keyword">for</code> <code class="sql keyword">No</code><code class="sql plain">) : y</code>
</div>
<div class="line number9 index8 alt2">
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">Disallow root login remotely? (Press y|Y </code><code class="sql keyword">for</code> <code class="sql plain">Yes, </code><code class="sql color1">any</code> <code class="sql plain">other </code><code class="sql keyword">key</code> <code class="sql keyword">for</code> <code class="sql keyword">No</code><code class="sql plain">) : y</code>
</div>
<div class="line number11 index10 alt2">
</div>
<div class="line number12 index11 alt1">
<code class="sql plain">Remove test </code><code class="sql keyword">database</code> <code class="sql color1">and</code> <code class="sql plain">access </code><code class="sql keyword">to</code> <code class="sql plain">it? (Press y|Y </code><code class="sql keyword">for</code> <code class="sql plain">Yes, </code><code class="sql color1">any</code> <code class="sql plain">other </code><code class="sql keyword">key</code> <code class="sql keyword">for</code> <code class="sql keyword">No</code><code class="sql plain">) : y</code>
</div>
<div class="line number13 index12 alt2">
</div>
<div class="line number14 index13 alt1">
<code class="sql plain">Reload privilege tables now? (Press y|Y </code><code class="sql keyword">for</code> <code class="sql plain">Yes, </code><code class="sql color1">any</code> <code class="sql plain">other </code><code class="sql keyword">key</code> <code class="sql keyword">for</code> <code class="sql keyword">No</code><code class="sql plain">) : y</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>6、mysql 服务加入开机启动项，并启动mysql进程</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_676760">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments">### Using Systemd</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">systemctl </code><code class="bash functions">enable</code> <code class="bash plain">mysqld.service</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">systemctl restart mysqld.service</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>7、开放3306端口</strong></p>
<p>
如果服务器开启了防火墙，记得开启3306端口</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_154734">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">systemctl </code><code class="bash functions">enable</code> <code class="bash plain">iptables</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">systemctl start iptables</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">vim </code><code class="bash plain">/etc/sysconfig/iptables</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash comments">##规则中加入</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash comments">##重启防火墙</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">systemctl </code><code class="bash functions">enable</code> <code class="bash plain">iptables.service</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">systemctl start iptables.service</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>
附mysql常用命令：</p>
<p>
登录mysql</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_311536">
<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 username -p</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</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_93398">
<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">systemctl start mysqld.service</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</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_832743">
<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">systemctl stop mysqld.service</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</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_376923">
<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">systemctl restart mysqld.service</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_740298">
<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">systemctl </code><code class="bash functions">enable</code> <code class="bash plain">mysqld.service</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
以上就是Centos7 安装 Mysql8教程的详细内容，更多关于Centos7 安装 Mysql8的资料请关注服务器之家其它相关文章！</p>
<p>
原文链接：https://cloud.tencent.com/developer/article/1649952</p>
頁:
[1]