安装

安装

yum

离线安装

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

tar -xvf ./mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

yum install \
    ./mysql-community-server-5.7.44-1.el7.x86_64.rpm \
    ./mysql-community-client-5.7.44-1.el7.x86_64.rpm \
    ./mysql-community-common-5.7.44-1.el7.x86_64.rpm \
    ./mysql-community-libs-5.7.44-1.el7.x86_64.rpm

默认配置

• /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
  

• /etc/systemd/system/multi-user.target.wants/mysqld.service

  # Copyright (c) 2015, 2023, Oracle and/or its affiliates.
  #
  # This program is free software; you can redistribute it and/or modify
  # it under the terms of the GNU General Public License, version 2.0,
  # as published by the Free Software Foundation.
  #
  # This program is also distributed with certain software (including
  # but not limited to OpenSSL) that is licensed under separate terms,
  # as designated in a particular file or component or in included license
  # documentation.  The authors of MySQL hereby grant you an additional
  # permission to link the program and your derivative works with the
  # separately licensed software that they have included with MySQL.
  #
  # This program is distributed in the hope that it will be useful,
  # but WITHOUT ANY WARRANTY; without even the implied warranty of
  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  # GNU General Public License, version 2.0, for more details.
  #
  # You should have received a copy of the GNU General Public License
  # along with this program; if not, write to the Free Software
  # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA
  #
  # systemd service file for MySQL forking server
  #
  
  [Unit]
  Description=MySQL Server
  Documentation=man:mysqld(8)
  Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
  After=network.target
  After=syslog.target
  
  [Install]
  WantedBy=multi-user.target
  
  [Service]
  User=mysql
  Group=mysql
  
  Type=forking
  
  PIDFile=/var/run/mysqld/mysqld.pid
  
  # Disable service start and stop timeout logic of systemd for mysqld service.
  TimeoutSec=0
  
  # Execute pre and post scripts as root
  PermissionsStartOnly=true
  
  # Needed to create system tables
  ExecStartPre=/usr/bin/mysqld_pre_systemd
  
  # Start main service
  ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS
  
  # Use this to switch malloc implementation
  EnvironmentFile=-/etc/sysconfig/mysql
  
  # Sets open_files_limit
  LimitNOFILE = 5000
  
  Restart=on-failure
  
  RestartPreventExitStatus=1
  
  PrivateTmp=false