MySQL 8.0 安装

来源于权威机构DB-Engines
的数据库最新排名，MySQL已经是全球占有率第二的数据库系统。

 MySQL 5.7官方已经停止支持， MySQL 8.0 发布引入多项新特性，在性能优化有很大提升是5.7的2倍。下面演示快速部署安装MySQL 8.0 。

 

1、下载mysql 8.0安装包

将MySQL Yum存储库添加到系统的存储库列表中。此操作为一次性操作，只需安装MySQL提供的RPM即可完成。Yum仓库下载对应的资源地址：MySQL :: Download MySQL Yum Repository

​

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

 rpm -ivh mysql80-community-release-el7-7.noarch.rpm

warning: mysql80-community-release-el7-7.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:mysql80-community-release-el7-7  ################################# [100%]

​

2、安装mysql-server 8.0

yum install mysql-server
Last metadata expiration check: 2:21:18 ago on Fri 19 May 2023 09:40:06 AM GMT.

Dependencies resolved.

========================================================================================================================================================================================

 Package                                Architecture                    Version                                                            Repository                              Size

========================================================================================================================================================================================

Installing:

 mysql-server                           x86_64                          8.0.30-1.module+el8.6.0+20849+f637f661                             ol8_appstream                           25 M

Installing dependencies:

 mecab                                  x86_64                          0.996-2.module+el8.6.0+20849+f637f661                              ol8_appstream                          393 k

 mysql-errmsg                           x86_64                          8.0.30-1.module+el8.6.0+20849+f637f661                             ol8_appstream                          619 k

 protobuf-lite                          x86_64                          3.5.0-15.el8                                                       ol8_appstream                          149 k

Transaction Summary

========================================================================================================================================================================================

Install  4 Packages

Total download size: 26 M

Installed size: 132 M

Is this ok [y/N]: y

2、启动mysql 服务

systemctl enable mysqld
systemctl start mysqld
systemctl status mysqld -l

3、获取初始密码

cat /var/log/mysqld.log | grep password

2023-05-19T12:07:06.725106Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

4、修改root密码
 

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '***************';

CREATE USER 'root'@'%' IDENTIFIED BY '***************';

grant all privileges on *.* to 'root'@'%';

select Host,User,plugin from user;

flush privileges;

恭喜您，MySQL 8.0已经碗装完毕，可以准备SQL倒入表结构啦！