Centos7.9rpm安装mysql教程(5.7与8.0通用)

最新推荐文章于 2024-07-12 23:15:02 发布

杀死一只知更鸟.

最新推荐文章于 2024-07-12 23:15:02 发布

阅读量559

点赞数 9

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_44683867/article/details/135011928

版权

rpm包下载

8.0:https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.35-1.el7.x86_64.rpm-bundle.tar

这里提供下载好的https://pan.baidu.com/s/1QHRZ3EPT25EPehS_YXEYoQ?pwd=qzlv

提取码：qzlv

更改yum源为国内清华大学源

sudo sed -e 's|^mirrorlist=|#mirrorlist=|g' \
         -e 's|^#baseurl=http://mirror.centos.org/centos|baseurl=https://mirrors.ustc.edu.cn/centos|g' \
         -i.bak \
         /etc/yum.repos.d/CentOS-Base.repo
#更新yum源
yum update

安装依赖包

 yum -y install net-tools  perl perl-Getopt-Long perl-strict

查看Centos自带的mariadb，如果有则卸载掉

[root@localhost ~]# rpm -qa|grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

解压软件包(解压位置不限)

tar xvf mysql-5.7.40-1.el7.x86_64.rpm-bundle.tar

按照顺序一安装5.7rpm包, 如果是8.0的包请看顺序二

顺序一:

rpm -ivh mysql-community-common-5.7.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.40-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.40-1.el7.x86_64.rpm

顺序二:

8.0 rmp安装顺序
rpm -ivh mysql-community-common-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.35-1.el7.x86_64.rpm

启动mysql并且查看密码

[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# grep 'password' /var/log/mysqld.log
2023-12-15T02:03:13.575153Z 1 [Note] A temporary password is generated for root@localhost: ciN<9xCChJJ9

登录mysql更改密码

#登录
mysql -uroot -p
#修改密码
mysql> alter user 'root'@'localhost' identified by '2020root$PWD';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
#允许以root身份远程登录mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '2020root$PWD' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)