MySQL 5.7.18 installation record under CentOS

A friend looking for me how to install mysql5.7.18 under Linux, I have a little to tidy up the next record, as follows:

：

MySQL5.7.18 Parameters official Website: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_user_ Connections, the package after download is mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

The above URL if not found, come to Baidu cloud disk Download: Link: https://pan.baidu.com/s/1bECiEM Password: c2my

Installation Script myql_install_5.7.18.sh, you can execute the script to implement this one-click installation Good mysql5.7.18:

#!/bin/bash# Install the Basie libuseradd mysql yum install cmake-yyum install-y libtoolizeyum install gcc gcc-c++-yyum Install-y Ncurses-devel.x86_64yum install-y cmake.x86_64yum install-y libaio.x86_64yum install-y Bison.x86_64yum Inst All-y gcc-c++.x86_64# UNZIPRM-RF/USR/LOCAL/MYSQL-5.7.18*TAR-XVF mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz-c/usr/ LOCALMV/USR/LOCAL/MYSQL-5.7.18-LINUX-GLIBC2.5-X86_64/USR/LOCAL/MYSQL3308CP my.cnf/tmp/cp/tmp/my.cnf/usr/local/ mysql3308/my.cnf# add MySQL account,create the basic directoryrm-rf/home/data/mysql3308/datamkdir-p/home/data/ Mysql3308/datacd/home/data/mysql3308/datachown-r mysql:mysql/usr/local/mysql3308mkdir-p/home/data/mysql3308/ Binlog/chown-r mysql:mysql/home/data/mysql3308/binlog/# Init databasesrm-rf/home/data/mysql3308/data/*cd/usr/ Local/mysql3308/time/usr/local/mysql3308/bin/mysqld--DEFAULTS-FILE=/USR/LOCAL/MYSQL3308/MY.CNF-- Initialize-insecure--user=mysql# "MySQL Enterprise Audit Security Considerations" #Mkdir-p/home/data/mysql/data/ssl/chown-r Mysql:mysql/home/data/mysql/data/sslcd/usr/local/mysql3308/time bin/ Mysql_ssl_rsa_setup--datadir=/home/data/mysql/data/ssl/# set the auto start on Linux server startedrm-rf/etc/init.d/my SQLD3308*CP support-files/mysql.server/etc/init.d/mysqld3308chmod 700/etc/init.d/mysqld3308echo "Export PATH= $PATH :/usr/local/mysql3308/bin ">>/etc/profile chkconfig--add mysqld3308source/etc/profilevim/etc/init.d/ mysqld3308basedir=/usr/local/mysql3308datadir=/home/data/mysql3308/data# start the MySQL serverecho "" >/usr/ Local/mysql3308/mysqld.logchown-r Mysql:mysql/usr/local/mysql3308/mysqld.logservice mysqld3308 Start

Start Error:

Background error log inside the start error message:

  2017-06-05t09:09:32.291104z 0 [note] Plugin ' Federated ' is disabled.2017-06-05t09:09:32.292966z 0 [note] Innodb:buffer Pool (s) load completed at 170605 17:09:322017-06-05t09:09:32.304707z 0 [Warning] Failed to set up SSL Becau SE of the following SSL library Error:ssl context is not usable without certificate and private key2017-06-05t09:09:32.30 4749Z 0 [Note] Server hostname (bind-address): ' * ';  port:33062017-06-05t09:09:32.304902z 0 [note] IPv6 is available.2017-06-05t09:09:32.304930z 0 [note]-':: ' resolves to ':: '; 2017-06-05t09:09:32.304964z 0 [Note] Server socket created on IP: ':: '. 2017-06-05t09:09:32.305012z 0 [ERROR] Can ' t s Tart server:bind on TCP/IP port:address already in use2017-06-05t09:09:32.305023z 0 [ERROR] does you already has another Mysqld server running on port:3306? 2017-06-05t09:09:32.305041z 0 [ERROR] aborting2017-06-05t09:09:32.305060z 0 [Note] Bi Nlog End  

Workaround, the following 2 actions can be
vim/etc/init.d/mysqld3308
(1) Turn basedir and datadir into the following
basedir=/usr/local/mysql3308
Datadir=/home/data/mysql3308/data

(2)
Turn all the/usr/local/mysql into/usr/local/mysql3308

And then reboot to get it done.

MySQL 5.7.18 installation record under CentOS