完整的mysql安装记录

墨蓝 2021-12-23 03:57 238阅读 0赞

[ 安装步骤记录][Link 1]

[admin@localhost ~]$ sudo wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'
    --2019-06-25 16:59:03--  https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
    正在解析主机 dev.mysql.com (dev.mysql.com)... 137.254.60.11
    正在连接 dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... 已连接。
    已发出 HTTP 请求，正在等待回应... 302 Found
    位置：https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm [跟随至新的 URL]
    --2019-06-25 16:59:16--  https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
    正在解析主机 repo.mysql.com (repo.mysql.com)... 23.57.113.239
    正在连接 repo.mysql.com (repo.mysql.com)|23.57.113.239|:443... 已连接。
    已发出 HTTP 请求，正在等待回应... 200 OK
    长度：25680 (25K) [application/x-redhat-package-manager]
    正在保存至: “mysql57-community-release-el7-11.noarch.rpm”
    
    100%[====================================================================================================================================================================================================================================>] 25,680      --.-K/s 用时 0s      
    
    2019-06-25 16:59:25 (211 MB/s) - 已保存 “mysql57-community-release-el7-11.noarch.rpm” [25680/25680])
    
    [admin@localhost ~]$ sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
    警告：mysql57-community-release-el7-11.noarch.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
    准备中...                          ################################# [100%]
    正在升级/安装...
       1:mysql57-community-release-el7-11 ################################# [100%]
    [admin@localhost ~]$ yum repolist all | grep mysql
    mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community      禁用
    mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - So 禁用
    mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community      禁用
    mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - So 禁用
    mysql-connectors-community/x86_64  MySQL Connectors Community       启用:    108
    mysql-connectors-community-source  MySQL Connectors Community - Sou 禁用
    mysql-tools-community/x86_64       MySQL Tools Community            启用:     90
    mysql-tools-community-source       MySQL Tools Community - Source   禁用
    mysql-tools-preview/x86_64         MySQL Tools Preview              禁用
    mysql-tools-preview-source         MySQL Tools Preview - Source     禁用
    mysql55-community/x86_64           MySQL 5.5 Community Server       禁用
    mysql55-community-source           MySQL 5.5 Community Server - Sou 禁用
    mysql56-community/x86_64           MySQL 5.6 Community Server       禁用
    mysql56-community-source           MySQL 5.6 Community Server - Sou 禁用
    mysql57-community/x86_64           MySQL 5.7 Community Server       启用:    347
    mysql57-community-source           MySQL 5.7 Community Server - Sou 禁用
    mysql80-community/x86_64           MySQL 8.0 Community Server       禁用
    mysql80-community-source           MySQL 8.0 Community Server - Sou 禁用
    [admin@localhost ~]$ yum install -y mysql-community-server
    已加载插件：fastestmirror
    您需要 root 权限执行此命令。
    [admin@localhost ~]$ sudo yum install -y mysql-community-server
    已加载插件：fastestmirror
    Loading mirror speeds from cached hostfile
     * base: mirrors.cn99.com
     * extras: mirror.jdcloud.com
     * updates: mirrors.cn99.com
    mysql-connectors-community                                                                                                                                                                                                                             | 2.5 kB  00:00:01     
    mysql-tools-community                                                                                                                                                                                                                                  | 2.5 kB  00:00:00     
    mysql57-community                                                                                                                                                                                                                                      | 2.5 kB  00:00:00     
    (1/3): mysql-tools-community/x86_64/primary_db                                                                                                                                                                                                         |  58 kB  00:00:03     
    (2/3): mysql-connectors-community/x86_64/primary_db                                                                                                                                                                                                    |  41 kB  00:00:03     
    (3/3): mysql57-community/x86_64/primary_db                                                                                                                                                                                                             | 177 kB  00:00:06     
    正在解决依赖关系
    --> 正在检查事务
    ---> 软件包 mysql-community-server.x86_64.0.5.7.26-1.el7 将被 安装
    --> 正在处理依赖关系 mysql-community-common(x86-64) = 5.7.26-1.el7，它被软件包 mysql-community-server-5.7.26-1.el7.x86_64 需要
    --> 正在处理依赖关系 mysql-community-client(x86-64) >= 5.7.9，它被软件包 mysql-community-server-5.7.26-1.el7.x86_64 需要
    --> 正在检查事务
    ---> 软件包 mysql-community-client.x86_64.0.5.7.26-1.el7 将被 安装
    --> 正在处理依赖关系 mysql-community-libs(x86-64) >= 5.7.9，它被软件包 mysql-community-client-5.7.26-1.el7.x86_64 需要
    ---> 软件包 mysql-community-common.x86_64.0.5.7.26-1.el7 将被 安装
    --> 正在检查事务
    ---> 软件包 mariadb-libs.x86_64.1.5.5.60-1.el7_5 将被 取代
    --> 正在处理依赖关系 libmysqlclient.so.18()(64bit)，它被软件包 2:postfix-2.10.1-7.el7.x86_64 需要
    --> 正在处理依赖关系 libmysqlclient.so.18(libmysqlclient_18)(64bit)，它被软件包 2:postfix-2.10.1-7.el7.x86_64 需要
    ---> 软件包 mysql-community-libs.x86_64.0.5.7.26-1.el7 将被 舍弃
    --> 正在检查事务
    ---> 软件包 mysql-community-libs-compat.x86_64.0.5.7.26-1.el7 将被 舍弃
    --> 解决依赖关系完成
    
    依赖关系解决
    
    ==============================================================================================================================================================================================================================================================================
     Package                                                                      架构                                                    版本                                                           源                                                                  大小
    ==============================================================================================================================================================================================================================================================================
    正在安装:
     mysql-community-libs                                                         x86_64                                                  5.7.26-1.el7                                                   mysql57-community                                                  2.2 M
          替换  mariadb-libs.x86_64 1:5.5.60-1.el7_5
     mysql-community-libs-compat                                                  x86_64                                                  5.7.26-1.el7                                                   mysql57-community                                                  2.0 M
          替换  mariadb-libs.x86_64 1:5.5.60-1.el7_5
     mysql-community-server                                                       x86_64                                                  5.7.26-1.el7                                                   mysql57-community                                                  166 M
    为依赖而安装:
     mysql-community-client                                                       x86_64                                                  5.7.26-1.el7                                                   mysql57-community                                                   24 M
     mysql-community-common                                                       x86_64                                                  5.7.26-1.el7                                                   mysql57-community                                                  274 k
    
    事务概要
    ==============================================================================================================================================================================================================================================================================
    安装  3 软件包 (+2 依赖软件包)
    
    总下载量：194 M
    Downloading packages:
    警告：/var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.26-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY                                                                                   ] 131 kB/s | 549 kB  00:25:12 ETA 
    mysql-community-common-5.7.26-1.el7.x86_64.rpm 的公钥尚未安装
    (1/5): mysql-community-common-5.7.26-1.el7.x86_64.rpm                                                                                                                                                                                                  | 274 kB  00:00:05     
    (2/5): mysql-community-libs-5.7.26-1.el7.x86_64.rpm                                                                                                                                                                                                    | 2.2 MB  00:00:05     
    (3/5): mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm                                                                                                                                                                                             | 2.0 MB  00:00:03     
    (4/5): mysql-community-client-5.7.26-1.el7.x86_64.rpm                                                                                                                                                                                                  |  24 MB  00:01:08     
    (5/5): mysql-community-server-5.7.26-1.el7.x86_64.rpm                                                                                                                                                                                                  | 166 MB  00:03:30     
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    总计                                                                                                                                                                                                                                          884 kB/s | 194 MB  00:03:44     
    从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥
    导入 GPG key 0x5072E1F5:
     用户ID     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
     指纹       : a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
     软件包     : mysql57-community-release-el7-11.noarch (installed)
     来自       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    警告：RPM 数据库已被非 yum 程序修改。
      正在安装    : mysql-community-common-5.7.26-1.el7.x86_64                                                                                                                                                                                                                1/6 
      正在安装    : mysql-community-libs-5.7.26-1.el7.x86_64                                                                                                                                                                                                                  2/6 
      正在安装    : mysql-community-client-5.7.26-1.el7.x86_64                                                                                                                                                                                                                3/6 
      正在安装    : mysql-community-server-5.7.26-1.el7.x86_64                                                                                                                                                                                                                4/6 
      正在安装    : mysql-community-libs-compat-5.7.26-1.el7.x86_64                                                                                                                                                                                                           5/6 
      正在删除    : 1:mariadb-libs-5.5.60-1.el7_5.x86_64                                                                                                                                                                                                                      6/6 
      验证中      : mysql-community-server-5.7.26-1.el7.x86_64                                                                                                                                                                                                                1/6 
      验证中      : mysql-community-client-5.7.26-1.el7.x86_64                                                                                                                                                                                                                2/6 
      验证中      : mysql-community-libs-5.7.26-1.el7.x86_64                                                                                                                                                                                                                  3/6 
      验证中      : mysql-community-libs-compat-5.7.26-1.el7.x86_64                                                                                                                                                                                                           4/6 
      验证中      : mysql-community-common-5.7.26-1.el7.x86_64                                                                                                                                                                                                                5/6 
      验证中      : 1:mariadb-libs-5.5.60-1.el7_5.x86_64                                                                                                                                                                                                                      6/6 
    
    已安装:
      mysql-community-libs.x86_64 0:5.7.26-1.el7                                            mysql-community-libs-compat.x86_64 0:5.7.26-1.el7                                            mysql-community-server.x86_64 0:5.7.26-1.el7                                           
    
    作为依赖被安装:
      mysql-community-client.x86_64 0:5.7.26-1.el7                                                                                          mysql-community-common.x86_64 0:5.7.26-1.el7                                                                                         
    
    替代:
      mariadb-libs.x86_64 1:5.5.60-1.el7_5                                                                                                                                                                                                                                        
    
    完毕！
    [admin@localhost ~]$ systemctl start mysqld
    ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
    Authentication is required to manage system services or units.
    Authenticating as: admin
    Password: 
    ==== AUTHENTICATION COMPLETE ===
    [admin@localhost ~]$ systemctl status mysqld
    ● mysqld.service - MySQL Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
       Active: active (running) since 二 2019-06-25 17:06:58 CST; 12s ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
      Process: 7699 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
      Process: 7626 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
     Main PID: 7702 (mysqld)
       CGroup: /system.slice/mysqld.service
               └─7702 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
    
    6月 25 17:06:55 localhost.localdomain systemd[1]: Starting MySQL Server...
    6月 25 17:06:58 localhost.localdomain systemd[1]: Started MySQL Server.
    [admin@localhost ~]$ grep 'temporary password' /var/log/mysqld.log
    2019-06-25T09:06:56.081634Z 1 [Note] A temporary password is generated for root@localhost: nhtEBa?&r9ME
    [admin@localhost ~]$ mysql -uroot -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.26
    
    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> SET PASSWORD = PASSWORD('123456');
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
    mysql> SET PASSWORD = PASSWORD('Admin123!');
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Admin123!' WITH GRANT OPTION;
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    | sys                |
    +--------------------+
    4 rows in set (0.00 sec)
    
    mysql> quit
    Bye
    [admin@localhost ~]$ vim /etc/my.cnf
    [admin@localhost ~]$ sudo vim /etc/my.cnf
    [sudo] admin 的密码：
    [admin@localhost ~]$ systemctl restart mysqld
    ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
    Authentication is required to manage system services or units.
    Authenticating as: admin
    Password: 
    ==== AUTHENTICATION COMPLETE ===
    [admin@localhost ~]$ systemctl enable mysqld
    ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-unit-files ===
    Authentication is required to manage system service or unit files.
    Authenticating as: admin
    Password: 
    ==== AUTHENTICATION COMPLETE ===
    ==== AUTHENTICATING FOR org.freedesktop.systemd1.reload-daemon ===
    Authentication is required to reload the systemd state.
    Authenticating as: admin
    Password: 
    ==== AUTHENTICATION COMPLETE ===
    [admin@localhost ~]$ sudo systemctl stop firewalld.service
    [sudo] admin 的密码：
    [admin@localhost ~]$ sudo systemctl start firewalld.service
    [admin@localhost ~]$ sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent;
    success
    [admin@localhost ~]$ sudo firewall-cmd --reload;
    success

[admin@localhost ~]$ sudo vim /etc/my.cnf
    
    # For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    
    [mysqld]
    #
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    #
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    #
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    character-set-server=utf8
    default-time_zone = '+8:00'
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[Link 1]: https://blog.csdn.net/qq_29278623/article/details/93635326