MySQL5.7.30二进制部署

官网下载二进制包

• wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

解压

• tar -zxf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
  cd /usr/local && mv mysql-5.7.30-linux-glibc2.12-x86_64/ mysql　
  cd mysql && mkdir data

配置环境变量

• echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
  source /etc/profile

创建MySQL用户并初始化

• useradd -s /sbin/nologin mysql -M
  chown -R mysql.mysql /usr/local/mysql/
  yum -y install libaio*
  mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

注：--initialize参数是开启临时密码、安全策略（密码过期时间）     --initialize-insecure：无密码即可登录

修改配置文件

• cp /etc/my.cnf /tmp
  
  vim /etc/my.cnf
  [mysqld]
  user=mysql
  bind-address=0.0.0.0
  basedir=/usr/local/mysql
  datadir=/usr/local/mysql/data
  socket=/tmp/mysql.sock
  server_id=1
  [mysql]
  socket=/tmp/mysql.sock
  

  　　

添加system管理启动

• vim  /usr/lib/systemd/system/mysqld.service
  
  [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
  ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
  LimitNOFILE = 5000
  

  　　

启动Mysql服务

• systemctl daemon-reload
  systemctl start mysqld
  netstat -lntp | grep 3306

　　注：MySQL历史版本下载：https://downloads.mysql.com/archives/community/