Linux - CentOS 7 通过Yum源安装 MySql 5.7
<h1><span>添加MySQL Yum存储库</span></h1><h3>从官网下载最新的mysql源</h3>
<p>官网地址：https://dev.mysql.com/downloads/repo/yum/ </p>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205114712879-2066513456.png" alt=""></p>
<p>选择并下载适用于平台的发行包。</p>
<p> <img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205115041575-438980388.png" alt=""></p>
<h3>然后，在Linux上打开终端并输入命令进行下载：</h3>
<div class="cnblogs_code">
<pre>wget https:<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm</span></pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205115442011-1679745617.png" alt=""></p>
<h3>使用以下命令安装下载的发行包</h3>
<p>-Uvh：升级软件包</p>
<div class="cnblogs_code">
<pre>rpm -Uvh mysql80-community-release-el7-<span style="color: rgba(128, 0, 128, 1)">3</span>.noarch.rpm</pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205120054498-137631149.png" alt=""></p>
<h1>选择发行版本，进行安装</h1>
<p><span>使用MySQL Yum存储库时，默认情况下会选择要安装的最新GA版本MySQL。</span><span>如果这是您想要的，则可以跳到下一步。</span></p>
<p><span><span>默认情况下，默认启用最新GA系列（当前为MySQL 8.0）的子存储库，而所有其他系列（例如，MySQL 5.7系列）的子存储库均被禁用。</span><span>使用此命令可查看MySQL Yum存储库中的所有子存储库，并查看已启用或禁用了哪些子存储库。</span></span></p>
<h3>列出所有版本</h3>
<div class="cnblogs_code">
<pre>yum repolist all | grep mysql</pre>
</div>
<p>发现8.0版本是enabled的，5.7版本是disabled的</p>
<p>这里我们需要安装5.7版本的，所以把8.0的进行禁用，然后再启用5.7版本</p>
<p>先禁用8.0版本：</p>
<div class="cnblogs_code">
<pre>yum-config-manager --disable mysql80-community</pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205120630040-1747379086.png" alt=""></p>
<p>运行 <span class="cnblogs_code">yum-config-manager</span>命令提示 <span class="cnblogs_code">-bash: yum-config-manager: command not found </span>命令未找到，因为 <span class="cnblogs_code">yum-config-manager</span> 在 <span class="cnblogs_code">yum-utils</span>包里面。由于系统默认没有这个命令，需要另外进行安装。</p>
<h3>安装yum-config-manager</h3>
<div class="cnblogs_code">
<pre>yum -y install yum-utils</pre>
</div>
<p>然后启用5.7版本</p>
<div class="cnblogs_code">
<pre>yum-config-manager --enable mysql57-community</pre>
</div>
<h3>检查启用版本</h3>
<p>进行安装时请确保只有一个版本启用，否则会显示版本冲突</p>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205121014958-540791878.png" alt=""></p>
<h3> 安装</h3>
<div class="cnblogs_code">
<pre>yum install mysql-community-server</pre>
</div>
<h3>安装时报错</h3>
<p>All matches were filtered out by modular filtering for argument: mysql-community-server</p>
<p>Error: Unable to find a match: mysql-community-server</p>
<p>解决办法：先执行 yum module disable mysql，然后再执行yum -y install mysql-community-server</p>
<p> <img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205121446386-1844797509.png" alt=""></p>
<p>直到出现 <span class="cnblogs_code">Complete!</span></p>
<h3>验证安装</h3>
<div class="cnblogs_code">
<pre>mysql --version</pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205121524069-1131406157.png" alt=""></p>
<p> 安装成功。</p>
<h1>启动MySql</h1>
<h3> 启动mysql服务</h3>
<div class="cnblogs_code">
<pre>sudo systemctl start mysqld.service</pre>
</div>
<h3>查看运行状态</h3>
<div class="cnblogs_code">
<pre>sudo systemctl status mysqld.service</pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205121956158-258615335.png" alt=""></p>
<h3>登录MySql</h3>
<p>MySql服务器初始化的时候会创建 'root@localhost'是一个超级用户账号。设置超级用户的密码并将其存储在错误日志文件中。要显示它，请使用以下命令：</p>
<div class="cnblogs_code">
<pre>sudo grep <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">temporary password</span><span style="color: rgba(128, 0, 0, 1)">'</span> /<span style="color: rgba(0, 0, 255, 1)">var</span>/log/mysqld.log</pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205152308162-1551071176.png" alt=""></p>
<p>然后通过生成的临时密码登录Mysql</p>
<p>输入以下命令</p>
<div class="cnblogs_code">
<pre>mysql -uroot -p</pre>
</div>
<p>输入密码</p>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205152451506-1650189570.png" alt=""></p>
<h3> 重置密码</h3>
<div class="cnblogs_code">
<pre>ALTER USER <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span>@<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">localhost</span><span style="color: rgba(128, 0, 0, 1)">'</span> IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">tengHao@2019</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205122816162-337356894.png" alt=""></p>
<h1>开启远程连接</h1>
<p>服务器首先需要开放3306端口，启用远程访问（<strong>MySQL默认禁止远程访问</strong>）。</p>
<h3>查看表</h3>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">show databases; -显示数据库
use mysql; -进入库</span></pre>
</div>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205154757132-1620383771.png" alt=""></p>
<p> 用 <span class="cnblogs_code"><span style="color: rgba(0, 0, 255, 1)">select</span> host ,user <span style="color: rgba(0, 0, 255, 1)">from</span> user;</span> 命令发现root用户的host是localhost，localhost 表示只能进行本地访问，不能进行远程连接</p>
<p><img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205123130955-620610379.png" alt=""></p>
<h3>修改权限</h3>
<p>把root用户的host改为% </p>
<div class="cnblogs_code">
<pre>update user <span style="color: rgba(0, 0, 255, 1)">set</span> host = <span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">%</span><span style="color: rgba(128, 0, 0, 1)">"</span> <span style="color: rgba(0, 0, 255, 1)">where</span> user = <span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">"</span>;</pre>
</div>
<p> <img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205123142351-1040315952.png" alt=""></p>
<h3> 刷新权限</h3>
<div class="cnblogs_code">
<pre>flush privileges;</pre>
</div>
<p> <img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205123200875-1461310279.png" alt=""></p>
<p>用 Navicat 测试连接</p>
<p> <img src="https://img2018.cnblogs.com/i-beta/1392738/201912/1392738-20191205132944373-1530657101.png" alt=""></p>
<p>mysql安装完成。</p>
<p>官方文档：https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/ </p>
<h1 class="title-article">如果连接出现： Table ‘performance_schema.session_variables’ doesn’t exist 错误</h1>
<h3>1.执行升级命令 </h3>
<div class="cnblogs_code">
<pre>mysql_upgrade -u root -p --force </pre>
</div>
<h3>1.重新启动MySql </h3>
<div class="cnblogs_code">
<pre>systemctl restart mysqld.service</pre>
</div>
<h1>修改MySQL编码</h1>
<h3>查看编码</h3>
<div class="cnblogs_code">
<pre>show variables like <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">character%</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
</div>
<p>打开配置文件my.cnf</p>
<p>在 <span class="cnblogs_code"></span> 跟 <span class="cnblogs_code"></span>下面添加 <span class="cnblogs_code"><span style="color: rgba(0, 0, 255, 1)">default</span>-character-<span style="color: rgba(0, 0, 255, 1)">set</span>=utf8</span> 然后重启mysql服务</p>
<h1>MYSQL常用命令 </h1>
<p>启动mysql服务：systemctl start mysqld.service</p>
<p>停止mysql服务：systemctl stop mysqld.service</p>
<p>重启mysql服务：systemctl restart mysqld.service</p>
<p>查看mysql服务当前状态：systemctl status mysqld.service</p>
<p>设置mysql服务开机自启动：systemctl enable mysqld.service</p>
<p>停止mysql服务开机自启动：systemctl disable mysqld.service</p>
<p>查看所有已启动的服务：systemctl list-units --type=service</p>
</div>
<div id="MySignature" role="contentinfo">
<div>作者：tenghao</div>
<div>出处：https://www.cnblogs.com/tenghao510/</div>
<div>此文章为原创，任何形式的转载都请注明出处！
若您觉得这篇文章还不错，请点击左下方的【大拇指】推荐一下，非常感谢！ </div><br><br>
来源：https://www.cnblogs.com/tenghao510/p/11988535.html
頁:
[1]