MySQL 5.7.10 Installation Documentation Tutorial

1. Install dependency packages

yum -y install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison

2. Install boost library:

First check whether boost has been installed

rpm -qa boost*

Uninstall old boost-* and other libraries:

yum -y remove boost-*

Download the Boost library, unzip it and copy it to the /usr/local/boost directory, then re-cmake and add the option -DWITH_BOOST=/usr/local/boost in the following options

(Download: http://sourceforge.NET/projects/boost/files/boost/)

Note: mysql5.7.10 requires boost version 1.59.0 and cannot be other versions

Download address: http://liquidtelecom.dl.sourceforge.Net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

3. Download MySQL source code

Official website download address: http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.10.tar.gz

Unzip after downloading

4. Installation process

(1) Create users and groups

# groupadd mysql
# mkdir /home/mysql #Custom location # mkdir /home/mysql/data #Custom location # useradd -g mysql -d /home/mysql mysql

(2) Compile MySQL

cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DMYSQL_DATADIR=/home/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

(3) Installation

If there is no error in the second step

make && make install

(4) Initialize the database

Enter the bin directory under the installation supplement and execute

./mysqld --initialize --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data

Note: A default password will be generated after initialization, please write it down

MySQL 5.7.10 Installation Documentation

(5) Adjust configuration files and environment variable parameters

Back up the default generated my.cnf

# mv /etc/my.cnf /etc/my.cnf.bak

Enter the mysql installation directory support file directory

# cd /mysql/support-files

Copy the configuration file template to a new mysql configuration file,

# cp my-default.cnf /etc/my.cnf

You can modify the new configuration file options as needed. If you do not modify the configuration options, MySQL will run with the default configuration parameters.

The following is my modification of the configuration file /etc/my.cnf to set the encoding to utf8 to prevent garbled characters

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
[client]
default-character-set=utf8

Copy the startup script to init.d

cp /mysql/support-files/mysql.server /etc/init.d/mysqld

Add execution permissions

chmod 755 /etc/init.d/mysqld

Create a mysql command file

ln -s /mysql/bin/mysql /usr/bin/

Note: Without this file, there is no mysql command, and you cannot use mysql to access the database at any location.

(6) Start MySQL

service mysqld start

(7) Accessing the database

mysql -uroot -p

The password is the one you just generated.

(8) Modify the default password

alter user 'root'@'localhost' identified by '123456';

Note: If you do not change the default password, you will not be able to use sql normally. You must change it

The above is the detailed explanation of the MySQL5.7.10 installation document tutorial introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!