数据库


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 &amp;&amp; rm -rf /etc/my.cnf &amp;&amp; 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>

页面列表

ITEM_HTML