MySQL 5.7.20 installed via RPM package on Redhat 7.2

First, installation environment

1. Operating system version: Red Hat Enterprise Linux Server Release 7.2 (Maipo)

2. mysql version: Mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

Second, installation instructions

1, the official website about MySQL 5.7 each RPM package is described as follows:

2, the official website about the mysql5.7 with RPM package installation of the various paths described below:

3, the official website on the standard installation needs to install which RPM package instructions are as follows:

4, official website about post-installation initialization instructions: using the RPM package after installation will automatically complete initialization when the service is first started, no need to manually perform the initialization operation

Third, the installation process

1, decompression Mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

2, unload the system in the Mariadb-libs

3, in order to install each RPM package, each RPM package has dependencies between, and finally install the mysql-community-server-5.7.20-1.el7.x86_64.rpm times the lack of dependent packages, use Yum installed, then install it no problem

4, check the relevant directory of MySQL, is empty

5, after the installation of the MySQL service has enabled, but did not start, start it

6, after starting the MySQL service, the log is as follows: It recorded the randomly generated initial root password "A temporary password is generated for [email protected]: urq2&okwzd,t"

2018-04-18t10:31:46.894089z 0 [warning] timestamp with implicit default  value is deprecated. please use --explicit_defaults_for_timestamp server  option  (see documentation for more details). 2018-04-18t10:31:50.089964z 0 [ warning] innodb: new log files created, lsn=457902018-04-18t10:31:50.319434z  0 [Warning] InnoDB: Creating foreign key constraint system  Tables.2018-04-18t10:31:50.380647z 0 [warning] no existing uuid has been  found, so we assume that this is the first time that  this server has been started. Generating a new UUID:  B44683a6-42f3-11e8-8b54-000c29ffe62f.2018-04-18t10:31:50.382406z 0 [warning] gtid table  is not ready to be used. table  ' mysql.gtid_executed '  cannot be opened.2018-04-18t10 : 31:50.383390z 1 [note] a temporary password is generated for [ Email protected]: urq2&okwzd,t2018-04-18t10:31:54.678495z 0 [warning] timestamp  with implicit default value is deprecated. please use --explicit _defaults_for_timestamp server option  (see documentation for more details). 2018-04-18t10:31:54.679697z 0 [note] /usr/sbin/mysqld  (mysqld 5.7.20)  starting  AS PROCESS 2954&NBSP, ..... 2018-04-18t10:31:54.685450z 0 [note] innodb: punch hole support  available2018-04-18t10:31:54.685476z 0 [note] innodb: mutexes and rw_locks  Use gcc atomic builtins2018-04-18t10:31:54.685479z 0 [note] innodb: useS event mutexes2018-04-18t10:31:54.685481z 0 [note] innodb: gcc builtin  __atomic_thread_fence ()  is used for memory barrier2018-04-18t10:31:54.685483z  0 [note] innodb: compressed tables use zlib 1.2.32018-04-18t10 : 31:54.685486z 0 [note] innodb: using linux native aio2018-04-18t10 : 31:54.685708z 0 [note] innodb: number of pools: 12018-04-18t10 : 31:54.685812z 0 [note] innodb: using cpu crc32 instructions2018-04-18t10 : 31:54.739376z 0 [note] innodb: initializing buffer pool, total size  = 128m, instances = 1, chunk size = 128m2018-04-18t10 :31:54.753795z 0 [note] innodb: completed initialization of buffer  Pool2018-04-18t10:31:54.758522z 0 [note] innodb: if the mysqld execution user is authorized, page cleaner  thread priority can be changed. see the man page of  SetPriority () .2018-04-18t10:31:54.772576z 0 [note] innodb: highest supported  file format is barracuda.2018-04-18t10:31:54.793537z 0 [note] innodb:  Creating shared tablespace for temporary tables2018-04-18t10:31:54.793646z 0  [Note] InnoDB: Setting file  './ibtmp1 '  size to 12 MB.  PHYSICALLY WRITING THE FILE FULL; PLEASE WAIT&NBSP, ..... 2018-04-18t10:31:54.952587z 0 [note] innodb: file  './ibtmp1 '  size is  now 12 mb.2018-04-18t10:31:54.955544z 0 [note] innodb: 96 redo  Rollback segment (s)  found. 96 redo rollback&Nbsp;segment (s)  are active.2018-04-18T10:31:54.955610Z 0 [Note] InnoDB: 32  Non-redo rollback segment (s)  are active.2018-04-18t10:31:54.957052z 0 [note]  innodb: waiting for purge to start2018-04-18t10:31:55.007837z 0 [note ] innodb: 5.7.20 started; log sequence number 25655232018-04-18t10 :31:55.009136z 0 [note] plugin  ' Federated '  is disabled.2018-04-18t10 : 31:55.018932z 0 [note] innodb: loading buffer pool (s)  from /var/lib/ Mysql/ib_buffer_pool2018-04-18t10:31:55.027051z 0 [note] innodb: buffer pool (s)   Load completed at 180418 18:31:552018-04-18t10:31:55.036775z 0 [note] found  ca.pem, server-cert.pem and server-key.pem in data directory. trying  to enable ssl support using them.2018-04-18t10:31:55.037779z 0 [warning] ca certificate  Ca.pem is self signed.2018-04-18t10:31:55.092734z 0 [note] server hostname   (bind-address):  ' * ';  port: 33062018-04-18t10:31:55.092981z 0 [note] ipv6  is available.2018-04-18T10:31:55.093007Z 0 [Note]   -  ':: '   resolves to  ':: '; 2018-04-18t10:31:55.093031z 0 [note] server socket created  on IP:  ':: ' .2018-04-18t10:31:55.107483z 0 [note] event scheduler:  Loaded 0 events2018-04-18t10:31:55.108147z 0 [note] /usr/sbin/mysqld: ready  for connections. version:  ' 5.7.20 '   socket:  '/var/lib/mysql/mysql.sock '   port: 3306   MySQL Community Server  (GPL) 2018-04-18t10:31:55.108170z 0 [note] executing  ' Select * from information_schema. TABLES; '  to get a list of tables using the deprecated partition  engine. You may use the startup option  '-- Disable-partition-engine-check '  to skip this check. 2018-04-18T10:31:55.108186Z  0 [note] beginning of list of non-natively partitioned  tables2018-04-18t10:31:55.124516z 0 [note] end of list of non-natively  partitioned tables

7, at this time to view the MySQL directory, related files have been automatically generated

8. Log in using the initial password recorded in the log and change the root password

9. Successful login with new password, installation complete

MySQL 5.7.20 installed via RPM package on Redhat 7.2