CentOS7 安装MySQL 8.0.28+

 MySQL的三大版本

a）MySQL Enterprise Edition：企业版本（付费）
b）MySQL Cluster CGE：高级集群版（收费）
c）MySQL Community Server：社区版（开源）

 

登录MySQL官网

https://www.mysql.com/downloads/

点击“DOCUMENTATION”——“MySQL Server”——“Installing and Upgrading MySQL”——“Installing MySQL on Linux”

点击：Installing MySQL on Linux Using the MySQL Yum Repository

点击：https://dev.mysql.com/downloads/repo/yum/

点击linux 7——download

右键复制链接地址

wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm

操作步骤如下：

cd /opt/
wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
yum install mysql80-community-release-el7-7.noarch.rpm
gcc -v
yum update
yum list | grep mysql
yum install mysql-community-server


root@jumpserver-app-t01:/opt#mysql -V
mysql  Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

启动mysqld服务

root@jumpserver-app-t01:/opt/mysql#systemctl start mysqld
root@jumpserver-app-t01:/opt/mysql#systemctl status mysqld
root@jumpserver-app-t01:/opt/mysql#systemctl enable mysqld
root@jumpserver-app-t01:/opt/mysql#

找到mysql的默认密码在这里：root@localhost: si<%<s%x7.On

root@jumpserver-app-t01:/var/log#cat /var/log/mysqld.log
2023-02-21T11:06:14.287837Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.32) initializing of server in progress as process 90720
2023-02-21T11:06:14.296083Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-21T11:06:14.658319Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-21T11:06:15.848026Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: si<%<s%x7.On
2023-02-21T11:06:18.815307Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 90787
2023-02-21T11:06:18.821989Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-21T11:06:18.911013Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-21T11:06:19.119711Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-02-21T11:06:19.119756Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-02-21T11:06:19.136298Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-02-21T11:06:19.136335Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
root@jumpserver-app-t01:/var/log#

此时需要到mysql中使用临时密码登录，并修改临时密码，因为临时密码是不可用的

mysql -uroot -p
si<%<s%x7.On

mysql> alter user root@'localhost' identified by'*******@666';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;    #刷新数据表信息后exit退出
Query OK, 0 rows affected (0.00 sec)
mysql>exit
Bye

注意1：第一次登录首先要做的是修改本地账号'root'@'localhost'的初始密码，并且刷新后才可以做下一步操作。

mysql> alter user 'root'@'localhost' identified by'abcdefghijklmn';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

注意2——定义纠正。在数据库中，'root'@'localhost'和'root'@'%'是两个账号，不要认为都是root，就是一个账号。所以想创建一个anywhere都可以访问的数据库root账号，要用Create命令。

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'abcdefghijklmn';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

注意3——授予权限： 创建新用户'root'@'%'后，你需要授予这个新用户相应的权限。对于 root 用户，通常是授予所有权限。你可以这样做：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

 

---

简单方法，去阿里源中找到mysql-community-server-8.0.28-1.el7.x86_64.rpm，下载到本地后，然后yum localinstall ./*

这样既能安装该组件，还能安装所需依赖

cd /opt
mkdir mysql
cd mysql
wget https://mirrors.aliyun.com/mysql/MySQL-8.0/mysql-community-server-8.0.28-1.el7.x86_64.rpm?spm=a2c6h.25603864.0.0.5e8670b2c1XZn4
yum localinstall ./*

后面一路选Y安装即可