Centos安装Mysql
<p>本文通过下载安装包方式进行安装，Centos版本7.9，Mysql版本8.0</p><h2 id="下载安装包">下载安装包</h2>
<p>1、进入网址 https://dev.mysql.com/downloads/mysql/<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913201313348-175567363.png"></p>
<p>2、选择对应版本进行下载，Centos系统选择Red Hat选项<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913201451285-542768426.png"></p>
<p>3、提示要登陆，点击No Thanks，just start my download进行下载<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913201747160-1333314144.png"></p>
<h2 id="卸载centos自带的mariadb">卸载Centos自带的Mariadb</h2>
<p>1、通过 <code>rpm -qa | grep mariadb</code> 命令查看 mariadb 的安装包<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913201854067-1612312108.png"></p>
<p>2、通过 <code>rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps</code> 命令装卸 mariadb<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913202148088-178984527.png"><br>
看到控制台没有任何输出是正常的</p>
<p>3、通过 <code>rpm -qa | grep mariadb</code> 命令再次查看 mariadb 的安装包，没有看到即可<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913202130745-358501757.png"></p>
<h2 id="检查是否有libaio库">检查是否有libaio库</h2>
<p>MySQL 依赖于该libaio 库。如果未在本地安装此库，则数据目录初始化和后续服务器启动步骤将失败。<br>
<code>yum search libaio</code><br>
<code>yum install libaio # install library</code></p>
<h2 id="安装mysql安装包">安装Mysql安装包</h2>
<p>1、通过 <code>cd /usr/local/</code> 命令进入根目录下的usr目录下的local目录，这个目录是放一些本地的共享资源的。并且通过<code>mkdir mysql</code>命令在当前目录下创建一个名为mysql的目录<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913202452423-1136750923.png"></p>
<p>2、将下载好的安装装包传输到该目录中<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913202650179-1150481139.png"></p>
<p>3、通过<code>tar -xvf mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar</code>解压安装包<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913202833604-279605062.png"></p>
<p>4、通过<code>rpm -ivh mysql-community-{模块名}-8.0.30-1.el7.x86_64.rpm --nodeps --force</code> 按顺序安装common、libs、client、server，最后通过<code>rpm -qa | grep mysql</code> 命令查看 mysql 的安装包，结果如下<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913203444941-1477174333.png"></p>
<p>5、通过以下命令，完成对 mysql 数据库的初始化和相关配置<br>
<code>mysqld --initialize</code>注意如果需要数据库支持忽略大小写则写成 <code>mysqld --initialize --lower-case-table-names=1</code> 因为Mysql8.0只支持在初始化时做修改，否则后期只能重新初始化！<br>
<code>chown mysql:mysql /var/lib/mysql -R</code><br>
<code>systemctl start mysqld.service</code><br>
<code>systemctl enable mysqld</code><br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913203722791-1565501039.png"></p>
<h2 id="设置mysql用户和远程连接">设置mysql用户和远程连接</h2>
<p>1、通过 cat /var/log/mysqld.log | grep password 命令查看数据库的密码<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913203815700-240510095.png"></p>
<p>2、通过 <code>mysql -uroot -p</code> 敲回车键进入数据库登陆界面，并输入刚才查看到的数据库密码<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913204000614-1625131466.png"><br>
看到这个界面就成功登录到mysql了</p>
<p>3、通过 <code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'</code> 命令来修改密码，我这里以修改密码成123456为例子。<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913204624392-30690256.png"></p>
<p>4、通过 <code>exit; </code>命令退出 MySQL，然后通过新密码再次登陆 <code>mysql -uroot -p123456</code><br>
再通过以下命令授权远程登陆<br>
<code>create user 'root'@'%' identified with mysql_native_password by '123456';</code><br>
<code>grant all privileges on *.* to 'root'@'%' with grant option;</code><br>
<code>flush privileges;</code><br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913204904404-163459193.png"></p>
<p>5、通过 <code>exit; </code>命令退出 MySQL，通过以下命令，关闭 firewall<br>
<code>systemctl stop firewalld.service</code><br>
<code>systemctl disable firewalld.service</code><br>
<code>systemctl mask firewalld.service</code><br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913205115765-720769530.png"></p>
<p>6、通过连接工具测试连接，连的上就说明设置成功啦！<br>
<img src="https://img2022.cnblogs.com/blog/2975501/202209/2975501-20220913205320337-710195212.png"></p>
<h2 id="修改mysql配置">修改Mysql配置</h2>
<p>通过以上安装方式，mysql配置文件路径为/etc/my.cnf<br>
如果需要修改配置文件，输入命令<code>systemctl restart mysqld</code>重启即可生效</p><br><br>
来源：https://www.cnblogs.com/jasonx1an/p/16690866.html
頁:
[1]