Shulou(Shulou.com)06/01 Report--

First, environmental preparation:

Operating system: CentOS Linux release 7.5.1804 (Core)

Mysql version: mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

IP:172.16.8.247

Second, mysql5.7 binary installation

1. Install the dependency package

Yum-y install libaio

2. Install mysql software

Download the software package:

Https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

Tar-xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz-C.. / cd.. mv mysql-5.7.24-linux-glibc2.12-x86_64/ mysql5.7useradd-s / sbin/nologin-M mysqlmkdir-p / app/mysql5.7/ {etc,logs,tmp}

3. Initialize data

Bin/mysqld-initialize-basedir=/app/mysql5.7/-datadir=/app/mysql5.7/data-user=mysql# bin/mysqld-initialize-basedir=/app/mysql5.7/-datadir=/app/mysql5.7/data-user=mysql2018-11-25T03:03:16.299117Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use-- explicit_defaults_for_timestamp server option (see documentation for more details). 2018-11-25T03:03:16.946059Z 0 [Warning] InnoDB: New log files created, LSN=457902018-11-25T03:03:17.033699Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2018-11-25T03:03:17.089657Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a7fef663-f05e-11e8-b1f5-08002728f0e4.2018-11-25T03:03:17.090377Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2018-11-25T03:03:17.090784Z 1 [Note] A temporary password is generated for root@localhost: MVV fw Bh 7on% > Bh

4. Modify the configuration file

Chown-R mysql .vim / app/mysql5.7/etc/ my.cnf [mysqld] daemonize = onuser = mysqlport = 3306basedir = / app/mysql5.7datadir = / app/mysql5.7/datasocket = / tmp/mysql.sockbind-address = 0.0.0.0pid-file = / app/mysql5.7/tmp/mysqld.pidcharacter-set-server = utf8collation-server = utf8_general_cimax_connections = 2408log-error = / app/mysql5.7/logs/mysqld.log

5. Systemd starts the MYSQL service

Vim / lib/systemd/system/ mysqld.service [unit] Description=MySQL ServerDocumentation=man:mysqld (8) Documentation= http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlType=forkingTimeoutSec=0PermissionsStartOnly=trueExecStart=/app/mysql5.7/bin/mysqld-- defaults-file=/app/mysql5.7/etc/my.cnfLimitNOFILE = 5000Restart=on-failureRestartPreventExitStartus=1PrivateTmp=false

6. Start the service

Systemctl restart mysqldsystemctl enable mysqld

7. Change the mysql root password

Vim / etc/profileexport PATH=$PATH:/app/mysql5.7/binsource / etc/profilemysql-uroot-palter user 'root'@'localhost' IDENTIFIED BY' Devops@2018'

Summary

The above is the Centos7.5 installation MySQL 5.7.24 binary package deployment introduced to you by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.