Home > Database > Mysql Tutorial > body text

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

黄舟
Release: 2017-03-29 13:59:44
Original
1908 people have browsed it

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
Copy after login

2. Create mysql user

#groupadd mysql
#useradd -r -g mysql -s /bin/false mysql
Copy after login

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
Copy after login

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
Copy after login

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/
Copy after login

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
Copy after login

Start directly

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

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

#mysql_secure_installation
Copy after login

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]
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!