Detailed explanation of CentOS7.4 source code installation MySQL8.0 tutorial

MySQL 8 official version 8.0.11 has been released, and officials say MySQL 8 is twice as fast as MySQL 5.7. it also brings a lot of improvements and faster performance!

The following is my record of the installation process on April 23, 2018. The whole process takes about an hour, and the make & & make install process takes a long time.

one。 Environment

CentOS7.4 64-bit minimized installation

two。 Preparatory work

1. Installation dependency

Yum-y install wget cmake gcc gcc-c++ ncurses ncurses-devel libaio-devel openssl openssl-devel

two。 Download the source package

Wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-8.0.11.tar.gz (this version comes with boost)

3. Create a mysql user

Groupadd mysql useradd-r-g mysql-s / bin/false mysql

4. Create installation directory and data directory

Mkdir-p / usr/local/mysql mkdir-p / data/mysql III. Install MySQL8.0.11

1. Decompress the source package

Tar-zxf mysql-boost-8.0.11.tar.gz-C / usr/local

two。 Compile & install

Cd / usr/local/mysql-8.0.11 cmake. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/usr/local/mysql/data-DSYSCONFDIR=/etc-DMYSQL_TCP_PORT=3306-DWITH_BOOST=/usr/local/mysql-8.0.11/boost make & & make install

3. Configure the my.cnf file

Cat / etc/my.cnf [mysqld] server-id=1 port=3306 basedir=/usr/local/mysql datadir=/data/mysql # # add parameters according to the actual situation

4. Directory permission modification

Chown-R mysql:mysql / usr/local/mysql chown-R mysql:mysql / data/mysql chmod 755 / usr/local/mysql-R chmod 755 / data/mysql-R

5. Initialization

Bin/mysqld-initialize-user=mysql-datadir=/data/mysql/ bin/mysql_ssl_rsa_setup

6. Start mysql

Bin/mysqld_safe-- user=mysql &

7. Change the account password

Bin/mysql-uroot-p mysql > alter user 'root'@'localhost' identified by "123456"; mysql > show databases +-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.00 sec) # # add Add remote special account mysql > create user root@'%' identified by '123456' Query OK, 0 rows affected (0.08 sec) mysql > grant all privileges on *. * to root@'%'; Query OK, 0 rows affected (0.04 sec) mysql > flush privileges; Query OK, 0 rows affected (0.01 sec)

8. Create a soft link (unnecessary)

Ln-s / usr/local/mysql/bin/* / usr/local/bin/ mysql-h 127.0.0.1-P 3306-uroot-p123456-e "select version () "mysql: [Warning] Using a password on the command line interface can be insecure. +-+ | version () | +-+ | 8.0.11 | +-+

9. Add to startup (not necessary)

Cp support-files/mysql.server / etc/init.d/mysql.server

Here is a note: MySQL officially recommends using binary installation. (the following is a screenshot of the official document)

Summary

The above is the detailed explanation of the CentOS7.4 source code installation MySQL8.0 tutorial introduced by the editor to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!