Detailed explanation of the installation tutorial of the latest stable version of mysql5.7.17 under Linux

This article mainly introduces the linuxmysql5.7.17 latest stable versioninstallation tutorial to everyone in detail. It has certain reference value and is of interest. Friends can refer to

Install the latest stable version of mysql on Linux through source code: mysql-5.7.17
In order to facilitate the installation process without being affected by boost dependency, download mysql directly from the official website- boost-5.7.17.tar.gz version. (Official explanation: Boost is required during the compilation process, but it is not actually used.)

Installation directory:

Startup script: /etc/ init.d/mysqld
Program root directory:/usr/local/mysql
Data directory:/data/mysql

Installation process

1. Install dependencies

#yum install -y cmake gcc-c++* make ncurses-devel

2. Create mysql user

#groupadd mysql
#useradd -r -g mysql -s /bin/false mysql

3. Download mysql-boost-5.7.17.tar.gz and upload it to the server

#tar xzf mysql-5.7.17.tar.gz 
#cd mysql-5.7.17
#mkdir bld
#cd bld/
#cmake .. -DWITH_BOOST=../boost/ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql 

#在此指定参数后减少很多后面启动过程中的操作
#make
#make install
#使用默认的配置文件
#cd /usr/local/mysql/support-files
#cp my-default.cnf ../my.cnf

#编译过程中出错，清除临时文件重新编译：
#make clean
#rm CMakeCache.txt

4 .After installation, add the executable file path to the system environment variable:

environment variable

#echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
#source /etc/profile

5. Initialize the database

#mkdir /data/mysql
#chown -R mysql.mysql /data/mysql
#mysqld --defaults-file=/usr/local/mysql/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/

After mysql5.7 is initialized, a password will be randomly generated and will be printed directly on the screen.

6. Startup
Copy the startup script:

#cd /usr/local/mysql/support-files
#cp mysql.server /etc/init.d/mysql

Start directly

#mysqld_safe --user=mysql &
或
#/etc/init.d/mysqld start

Call the security script after startup, implement: change root password, deletetest library, prohibit rootremote login

#mysql_secure_installation

partial configuration (not optimized)

[client]
port=3306
socket=/tmp/mysql.sock
character_set_client= utf8
[mysqld]
basedir = /usr/local/mysql
datadir = /data/mysql
port = 3306
socket = /tmp/mysql.sock
character-set-server = utf8
read_buffer_size=131072
#innodb
innodb_data_file_path=ibdata1:100M:autoextend
#binlog
server_id=1
log-bin=mysql-bin
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
[myisamchk]

The above is the detailed content of Detailed explanation of the installation tutorial of the latest stable version of mysql5.7.17 under Linux. For more information, please follow other related articles on the PHP Chinese website!