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

Installation and configuration of mysql5.7.13 based on rhel7.2

First, the experimental environment:

(1) Virtual machine: vmware workstation 12

(2) operating system: rhel 7.2x86x64

(3) Database: mysql5.7.13

2. The main features of MySQL 5.7:

Native support for Systemd

Better performance: better optimization for multicore CPU, solid state drives, and locks

Better InnoDB storage engine

More robust replication: replication brings a solution that does not lose data at all, and traditional financial customers can also choose to use MySQL databases.

Note: multithreaded master-slave replication has been supported since the mysql5.6.3 version.

New sys library: this will be the most frequently accessed library by DBA in the future

Better optimizer: the meaning of optimizer code refactoring will bring huge improvements in this and later versions, and Oracle officials are solving the biggest problem before MySQL: native JSON type support (JavaScript Object Notation).

Note: JSON (JavaScript Object Notation) is a lightweight data exchange format. JSON uses a completely language-independent text format, but also uses conventions similar to the C language family (including C, C++, C #, Java, JavaScript, Perl, Python, and so on). These features make JSON an ideal data exchange language. It is easy for people to read and write, and it is also easy to be parsed and generated by machines (generally used to increase the network transmission rate).

The JSON syntax is a subset of the syntax represented by JavaScript objects.

The data is in the key value pair

Data is separated by commas

Curly braces save objects

Square brackets save array

Files written in JSON can replace files in .yaml format. (this is used in docker kubernetes to create a RC).

Third, view and delete the database that comes with the system

[root@localhost ~] # uname-r

3.10.0-327.el7.x86_64

[root@localhost ~] # cat / etc/redhat-release

Red Hat Enterprise Linux Server release 7.2 (Maipo)

[root@localhost ~] # rpm-qa | grep mariadb

Mariadb-libs-5.5.44-2.el7.x86_64

[root@localhost] # rpm-e mariadb-libs-- nodeps

[root@localhost ~] # rpm-qa | grep mariadb

Note: since mariadb-libs is installed by default in centos7.2, uninstall it first.

First check to see if mariadb is installed on this system. The rpm package installation of mysql is no longer supported from the linux7 version, so there is no mysql rpm package in the system disk. At the same time, starting from the linux7 version, the system will install the mariadb-libs database by default, and there will be conflicts when we install the mysql database, so we have to uninstall the mariadb-libs database first.

Fourth, rely on package download

(1) the role of related dependency packages

Cmake: since the regular configure compilation method has been deprecated from the MySQL5.5 version, a CMake compiler is required to set the compilation parameters for mysql. Such as: installation directory, data storage directory, character encoding, sorting rules and so on.

Boost: starting from MySQL 5.7.5, the Boost library is required. C++ 's Boost library is used in the mysql source code, and boost1.59.0 or above is required.

GCC: is a C language compilation tool under Linux. Mysql source code compilation is written entirely in C and C++. GCC is required to be installed.

C _ syntax + parser under bison:Linux

Ncurses: character terminal processing library

(2) preparation of installation documents

Download cmake-3.5.tar.gz

Download ncurses-5.9.tar.gz

Download bison-3.0.4.tar.gz

Download mysql-5.7.13.tar.gz

Download Boost_1_59_0.tar.gz

5. Dependent package installation

(1) install cmake

[root@localhost ~] # cd / usr/src

[root@ src] # tar-zxvf cmake-3.5.2.tar.gz

[root@ src] # cd cmake-3.5.2

[root@ cmake-3.5.2] # / bootstrap & & gmake & & gmake install

Note: if an error is reported in the previous step, please install the following package:

[root@localhost cmake-3.5.2] # yum install-y gcc

[root@localhost cmake-3.5.2] # yum install-y gcc-c++.x86_64

Cmake-version-View the cmake version

[root@ cmake-3.5.2] # cmake- version

Cmake version 3.5.2

CMake suite maintained and supported by Kitware (kitware.com/cmake).

(2) install ncurses

[root@ src] # tar zxvf ncurses-5.9.tar.gz

[root@ ncurses-5.9] # / configure & & make & & make install

(3) install bison

[root@ src] # tar-zxvf bison-3.0.4.tar.gz

[root@ src] # cd bison-3.0.4

[root@ bison-3.0.4] # / configure & & make & & make install

Note: if an error is reported in the previous step, it is as follows:

Error 1::checking for GNU M4 that supports accurate traces... Configure: error: no acceptable M4 could be found in $PATH.

Installation:

[root@localhost bison-3.0.4] # yum install-y m4.x86_64

Error 2:configure: error: perl not found

[root@localhost bison-3.0.4] # yum install-y perl.x86_64

(4) install bootst

[root@ src] # tar-zxvf boost_1_59_0.tar.gz

[root@ src] # mv boost_1_59_0 / usr/local/boost

Create mysql users and user groups and directories

(1) create mysql users and user groups

[root@] # groupadd-r mysql & & useradd-r-g mysql-s / bin/false-M mysql

Note: the above command means that new mysql groups and mysql users are prohibited from logging in to shell. The above command can also be written as follows:

Useradd-r-s / sbin/nologin-M mysql

-r means to create a system component or system account.

Take a look at the mysql account created:

[root@localhost ~] # cat / etc/passwd | grep mysql

Mysql:x:996:994::/home/mysql:/bin/false

(2) create a mysql installation directory

[root@ ~] # mkdir / usr/local/mysql

(3) create the directory where the database is located

[root@ ~] # mkdir / usr/local/mysql/data

7. Compile, install and optimize mysql

(1) decompress mysql

[root@ src] # tar-zxvf mysql-5.7.13.tar.gz

(2) compile and install mysql

[root@ src] # cd mysql-5.7.13

[root@ mysql-5.7.13] # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/usr/local/mysql/data-DSYSCONFDIR=/etc-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE=1-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock-DWITH_PARTITION_STORAGE_ENGING=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=uft8-DDEFAULT_COLLATION=uft8_general_ci-DWITH-SYSTEMD=1-DWITH_BOOST=/usr/local/boost & & make & & make install

Note: do not write in bold font!

Note: to rerun the cmake configuration, you need to delete the CMakeCache.txt file (that is, there are errors found after the previous configuration, compilation and installation, so we don't have to start all over again and just delete the CMakeCache.txt file)

The steps are as follows:

(3) optimize the execution path of Mysql:

[root@ mysql-5.7.13] # vim / etc/profile

Add: export PATH=$PATH:/usr/local/mysql/bin at the bottom

[root@ mysql-5.7.13] # source / etc/profile

(4) set permissions and initialize MySQL system authorization table

[root@] # chown-R mysql:mysql / usr/local/mysql/

Initialize the database, command:

[root@localhost] # / usr/local/mysql/bin/mysqld-initialize-user=mysql-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data

Note: in the figure above, mysql generates a default password: rY9V) w5ixjhL

Description: (installation mode or non-installation mode can be used after version 5.7.6)

(5) change the owner and group again just in case.

(6) create a configuration file

Modify the my.cnf configuration file:

(7) configure mysql to boot automatically

[root@localhost ~] # cd / usr/lib/systemd/system/

[root@localhost system] # vim mysqld.service

The configuration file is as follows:

[Unit]

Description=MySQL Server

After=network.target

[Service]

ExecStart=/usr/local/mysql/bin/mysqld-defaults-file=/etc/my.cnf-datadir=/usr/local/mysql/data-socket=/usr/local/mysql/mysql.sock

User=mysql

Group=mysql

[Install]

WantedBy=multi-user.target

Quit and save!

[root@localhost system] # systemctl daemon-reload # # reload systemd and scan for new or changed units to take effect.

(8) start mysql again and check the status

[root@localhost system] # systemctl start mysqld.service

[root@localhost system] # systemctl status mysqld.service

[root@localhost mysql] # ps-ef | grep mysqld

[root@localhost mysql] # netstat-lnp | grep mysql

8. Access the database:

(1) Log in to the database with the default password

[root@localhost mysql] # mysql-u root-p 'rY9V) w5ixjhL'

(2) modify the database password

Mysql > mysqladmin-uroot-p'rY9V) w5ixjhL'password'123456'

Note:

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.