centos7上安装mysql8.0

短命女 2022-03-16 10:36 290阅读 0赞

## 1 yum安装 ##

[官网yum安装方法][yum]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70 1][]

### 1.1 获取MySQL8.0 YUM源 ###

进入mysql官网获取RPM包下载地址，上面截图已经给出操作步骤

# 获取到下载链接：
    https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

### 1.2 下载和安装mysql源 ###

下载mysql源
    wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
    
    安装mysql源
    yum -y localinstall mysql80-community-release-el7-1.noarch.rpm

### 1.3 在线安装MySQL ###

yum -y install mysql-community-server

安装过程，安装时间比较长，由网速决定。

[root@wyl01 ~]# yum -y install mysql-community-server
    Loaded plugins: fastestmirror, langpacks
    Determining fastest mirrors
     * base: mirrors.aliyun.com
     * extras: mirrors.aliyun.com
     * updates: mirrors.aliyun.com
    (1/2): mysql-connectors-community/x86_64/primary_db                                                          |  37 kB  00:00:00     
    mysql-tools-community/x86_64/p FAILED                                          
    http://repo.mysql.com/yum/mysql-tools-community/el/7/x86_64/repodata/5f5c8d66d01cebe1ed0fdd8710b411b96b9161c1-primary.sqlite.bz2: [Errno 14] curl#7 - "Failed connect to repo.mysql.com:80; Connection refused"
    Trying other mirror.
    mysql-tools-community/x86_64/p FAILED                                          
    http://repo.mysql.com/yum/mysql-tools-community/el/7/x86_64/repodata/5f5c8d66d01cebe1ed0fdd8710b411b96b9161c1-primary.sqlite.bz2: [Errno 14] curl#7 - "Failed connect to repo.mysql.com:80; Connection refused"
    Trying other mirror.
    mysql-tools-community/x86_64/p FAILED                                          
    http://repo.mysql.com/yum/mysql-tools-community/el/7/x86_64/repodata/5f5c8d66d01cebe1ed0fdd8710b411b96b9161c1-primary.sqlite.bz2: [Errno 14] curl#7 - "Failed connect to repo.mysql.com:80; Connection refused"
    Trying other mirror.
    (2/2): mysql-tools-community/x86_64/primary_db                                                               |  54 kB  00:00:00     
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql-community-server.x86_64 0:8.0.15-1.el7 will be installed
    --> Processing Dependency: mysql-community-common(x86-64) = 8.0.15-1.el7 for package: mysql-community-server-8.0.15-1.el7.x86_64
    --> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.15-1.el7.x86_64
    --> Running transaction check
    ---> Package mysql-community-client.x86_64 0:8.0.15-1.el7 will be installed
    --> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.0 for package: mysql-community-client-8.0.15-1.el7.x86_64
    ---> Package mysql-community-common.x86_64 0:8.0.15-1.el7 will be installed
    --> Running transaction check
    ---> Package mariadb-libs.x86_64 1:5.5.52-1.el7 will be obsoleted
    --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
    --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
    ---> Package mysql-community-libs.x86_64 0:8.0.15-1.el7 will be obsoleting
    --> Running transaction check
    ---> Package mysql-community-libs-compat.x86_64 0:8.0.15-1.el7 will be obsoleting
    ---> Package postfix.x86_64 2:2.10.1-6.el7 will be updated
    ---> Package postfix.x86_64 2:2.10.1-7.el7 will be an update
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ====================================================================================================================================
     Package                                   Arch                 Version                       Repository                       Size
    ====================================================================================================================================
    Installing:
     mysql-community-libs                      x86_64               8.0.15-1.el7                  mysql80-community               2.2 M
         replacing  mariadb-libs.x86_64 1:5.5.52-1.el7
     mysql-community-libs-compat               x86_64               8.0.15-1.el7                  mysql80-community               2.1 M
         replacing  mariadb-libs.x86_64 1:5.5.52-1.el7
     mysql-community-server                    x86_64               8.0.15-1.el7                  mysql80-community               360 M
    Installing for dependencies:
     mysql-community-client                    x86_64               8.0.15-1.el7                  mysql80-community                25 M
     mysql-community-common                    x86_64               8.0.15-1.el7                  mysql80-community               566 k
    Updating for dependencies:
     postfix                                   x86_64               2:2.10.1-7.el7                base                            2.4 M
    
    Transaction Summary
    ====================================================================================================================================
    Install  3 Packages (+2 Dependent packages)
    Upgrade             ( 1 Dependent package)
    
    Total size: 393 M
    Total download size: 391 M
    Downloading packages:

### 1.4 启动mysql服务 ###

#启动mysql服务
    systemctl start mysqld
    
    #查看进程
    ps -ef |grep mysql
    systemd+   3649      1  0 Feb16 ?        01:34:00 mysqld
    root       4097   3649  0 Feb16 ?        00:00:00 [mysql] <defunct>
    mysql     84152      1 11 15:15 ?        00:00:01 /usr/sbin/mysqld
    
    
    #设置开机自启动
    systemctl enable mysqld

### 1.5 修改root登陆密码，可远程连接 ###

mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个临时的默认密码，用grep命令搜一下。

[root@wyl01 local]# grep -R "password" /var/log/mysqld.log 
    2019-02-27T07:15:07.717147Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: h80yjbjIjL*y

进入mysql服务后，我们查看数据库操作，发现下面的错误信息

[root@wyl01 ~]# mysql -uroot -ph80yjbjIjL*y
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 8
    Server version: 8.0.15
    
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> show databases;
    ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
    mysql>

提示我们需要先修改密码，这里的修改密码方式和之前的版本不同，密码的长度和密码的要求也不一样，这里至少包含大小写字母数字和特殊字符。

alter user 'root'@'localhost' identified by 'QWer12#$';

修改完密码后，我们的本地远程访问还是不行的，我们查看一下原因

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70 2][]

所以我们要将host=‘localhost’改成‘%’

update mysql.user set host='%' where user='root';
    flush privileges;

至此，我们mysql8.0版本安装结束。

## 2 二进制包安装 ##

### 2.1 下载安装包 ###

[下载地址][Link 1]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70 3][]

### 2.2 安装方法和mysql5.7安装方法一样 ###

[mysql5.7安装步骤][mysql5.7]

[yum]: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70]: /images/20220316/45137c14d180497987cc2a38ff895f79.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70 1]: /images/20220316/a7b5517a556d4047928d2e383a7c042b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70 2]: /images/20220316/c119edc57b5e4d6995fc5990fd6920a7.png
[Link 1]: https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.15-linux-glibc2.12-x86_64.tar
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d5bDk1Mjc_size_16_color_FFFFFF_t_70 3]: /images/20220316/88e6d7f008d448518bb513e32a86870b.png
[mysql5.7]: https://blog.csdn.net/wyl9527/article/details/78829353