03_Centos 8 下yum安装MySQL8.0
<h3>1、检查是否已安装(强力卸载)</h3>
<pre><code class="language-bash">for i in $(rpm -qa|grep mysql);do
rpm -e $i --nodeps;done
rm -rf /var/lib/mysql && rm -rf /etc/my.cnf && rm -rf /usr/share/mysql</code></pre>
<p>备注:可配合以下方式查找</p>
<pre><code class="language-bash">whereis mysql
find /-name mysql
yum remove mysql mysql-server mysql-libs</code></pre>
<h3>2.添加MySQL8.0的yum源</h3>
<pre><code class="language-bash">rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm</code></pre>
<h3>3.yum安装</h3>
<pre><code class="language-bash">yum update -y
yum -y install mysql-server</code></pre>
<h3>4.查看mysql是否安装成功</h3>
<pre><code class="language-bash">rpm -qa |grep mysql
ps -ef | grep mysql
mysqladmin --version</code></pre>
<h3>5.启动mysql服务</h3>
<pre><code class="language-bash">systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld</code></pre>
<h3>6.相关安装目录</h3>
<pre><code class="language-bash">/usr/bin //相关命令
/usr/share/mysql //配置文件目录
/var/lib/mysql //数据库文件存放目录
/etc/my.cnf.d //mysql的启动配置文件
* client.cnf //mysql客户端配置文件
* mysql-server.cnf //mysql守护进程配置文件
* mysql-default-authentication-plugin.cnf //默认权限授权配置文件
备注:可复制一份到/etc下,修改成my.cnf</code></pre>
<h3>7.mysql登录(不用密码登录)</h3>
<pre><code class="language-bash">mysql -uroot</code></pre>
<h3>8.重置root密码</h3>
<pre><code class="language-bash">use mysql; //选择数据库
alter user 'root'@'localhost' identified by'root'; //修改密码
flush privileges; //刷新权限表
备注:mysql8.0修改用户密码命令(新的修改方式)</code></pre>
<h3>9.重新登录(使用新密码)</h3>
<pre><code class="language-bash">mysql -uroot -p</code></pre>
<p>来源:
本文yum安装法:
<a href="https://baijiahao.baidu.com/s?id=1656793973110577341&wfr=spider&for=pc">https://baijiahao.baidu.com/s?id=1656793973110577341&wfr=spider&for=pc</a>
另一种yum安装法:
<a href="https://www.mf8.biz/rhel8-centos8-install-mysql-8-0/">https://www.mf8.biz/rhel8-centos8-install-mysql-8-0/</a></p>