A brief analysis of the tutorial on installing MySQL 8.0.18 on CentOS 6.8 (RPM method)

[root@binghe151 src]# rpm -qa | grep -i mysql    
mysql-libs-5.1.73-7.el6.x86_64

[root@binghe151 src]# rpm -e mysql-libs-5.1.73-7.el6.x86_64 --nodeps 
[root@binghe151 src]#

[root@binghe151 src]# rpm -qa | grep -i mysql
[root@binghe151 src]#

yum -y install wget gcc-c++ ncurses ncurses-devel cmake make perl bison openssl openssl-devel gcc* libxml2 libxml2-devel curl-devel libjpeg* libpng* freetype* make gcc-c++ cmake bison-devel ncurses-devel bison perl perl-devel perl perl-devel net-tools* numactl*

groupadd mysql
useradd -g mysql mysql

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.18-1.el6.x86_64.rpm-bundle.tar

[root@binghe151 src]# ll
total 744876
-rw-r--r--. 1 root root 762746880 Nov 18 14:32 mysql-8.0.18-1.el6.x86_64.rpm-bundle.tar

[root@binghe151 src]# tar xvf mysql-8.0.18-1.el6.x86_64.rpm-bundle.tar 
mysql-community-client-8.0.18-1.el6.x86_64.rpm
mysql-community-test-8.0.18-1.el6.x86_64.rpm
mysql-community-server-8.0.18-1.el6.x86_64.rpm
mysql-community-libs-compat-8.0.18-1.el6.x86_64.rpm
mysql-community-common-8.0.18-1.el6.x86_64.rpm
mysql-community-devel-8.0.18-1.el6.x86_64.rpm
mysql-community-libs-8.0.18-1.el6.x86_64.rpm

mysql-community-common-8.0.18-1.el6.x86_64.rpm
mysql-community-libs-8.0.18-1.el6.x86_64.rpm
mysql-community-client-8.0.18-1.el6.x86_64.rpm
mysql-community-server-8.0.18-1.el6.x86_64.rpm

[root@binghe151 src]# rpm -ivh mysql-community-common-8.0.18-1.el6.x86_64.rpm
warning: mysql-community-common-8.0.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ############################################# [100%]
 1:mysql-community-common ############################################### [100%]

[root@binghe151 src]# rpm -ivh mysql-community-libs-8.0.18-1.el6.x86_64.rpm
warning: mysql-community-libs-8.0.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ############################################# [100%]
 1:mysql-community-libs ############################################### [100%]

[root@binghe151 src]# rpm -ivh mysql-community-client-8.0.18-1.el6.x86_64.rpm
warning: mysql-community-client-8.0.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ############################################# [100%]
 1:mysql-community-client ############################################### [100%]

[root@binghe151 src]# rpm -ivh mysql-community-server-8.0.18-1.el6.x86_64.rpm
warning: mysql-community-server-8.0.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ############################################# [100%]
 1:mysql-community-server ############################################## [100%]

[root@binghe151 src]# rpm -ivh mysql-community-server-8.0.18-1.el6.x86_64.rpm
warning: mysql-community-server-8.0.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
  libnuma.so.1()(64bit) is needed by mysql-community-server-8.0.18-1.el6.x86_64
  libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-8.0.18-1.el6.x86_64
  libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-8.0.18-1.el6.x86_64

shell> bin/mysqld --initialize --user=mysql
shell> bin/mysqld --initialize-insecure --user=mysql

shell> bin/mysqld --initialize
shell> bin/mysqld --initialize-insecure

mysqld --initialize --user=mysql
mysqld --initialize-insecure --user=mysql

mysqld --initialize
mysqld --initialize-insecure

mkdir -p /usr/local/mysql
chown -R mysql.mysql /usr/local/mysql
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

[root@binghe151 src]# service mysqld start
Starting mysqld: 
[ OK ]

vim /var/log/mysqld.log 
2019-11-18T08:16:08.162464Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.18) initializing of server in progress as process 2111
2019-11-18T08:16:12.451542Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: -8cagKkdK#5G
2019-11-18T08:17:13.269505Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18) started as process 2378
2019-11-18T08:17:16.568836Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-11-18T08:17:16.642494Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.18' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2019-11-18T08:17:16.652000Z 7 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instea
d'
2019-11-18T08:17:16.801986Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060

2019-11-18T08:16:12.451542Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: -8cagKkdK#5G

[root@binghe151 src]# mysql -uroot -p-8cagKkdK#5G
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.18
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

mysql> SHOW DATABASES;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.03 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@binghe151 src]# mysql -uroot -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.18 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
|mysql |
| performance_schema |
|sys|
+--------------------+
4 rows in set (0.36 sec)
mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>

mkdir -p /usr/local/mysql
chown -R mysql.mysql /usr/local/mysql
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
Then you can configure the my.cnf file as shown below.
[client]
port = 3306
#Adjust mysql.sock configuration according to actual situation socket = /tmp/mysql.sock
[mysqld]
#Unique ID of MySQL service Each MySQL service ID needs to be unique server-id = 1
#The default service port number is 3306
port = 3306
#mysql installation root directory basedir = /usr/local/mysql
#mysql data file location datadir = /usr/local/mysql/data
#pid
pid-file = /usr/local/mysql/mysql.pid
#Set the directory where the socke file is located socket = /tmp/mysql.sock
#Set the temporary directory tmpdir = /tmp
# User user = mysql
# Allow access to the IP network segment bind-address = 0.0.0.0
# Skip password login#skip-grant-tables
#Mainly used for MyISAM storage engine. If multiple servers are connected to one database, it is recommended to comment the following content skip-external-locking
#Only use IP address to check client login, not host name skip_name_resolve = 1
#Transaction isolation level, the default is repeatable read, MySQL default repeatable read level (at this level, there may be many gap locks in the parameters, affecting performance)
transaction_isolation = READ-COMMITTED
#The database default character set, the mainstream character set supports some special emoticons (special emoticons occupy 4 bytes)
character-set-server = utf8mb4
#The database character set corresponds to some sorting rules. Note that it should correspond to character-set-server collation-server = utf8mb4_general_ci
#Set the character set when the client connects to mysql to prevent garbled characters init_connect='SET NAMES utf8mb4'
#Whether to case-sensitive SQL statements, 1 means insensitive lower_case_table_names = 1
#Maximum number of connections max_connections = 400
#Maximum number of connection errors max_connect_errors = 1000
#TIMESTAMP If NOT NULL is not explicitly declared, NULL values ​​are allowed explicit_defaults_for_timestamp = true
#SQL data packet size, if there is a BLOB object, it is recommended to change it to 1G
max_allowed_packet = 128M
#MySQL connections will be forcibly closed after being idle for a certain period of time (in seconds) #MySQL's default wait_timeout value is 8 hours, and the interactive_timeout parameter needs to be configured at the same time to take effect interactive_timeout = 1800
wait_timeout = 1800
#The maximum value of the internal memory temporary table is set to 128M.
#For example, a temporary table may be used when grouping or ordering large amounts of data.
#If the value exceeds this value, the table will be written to disk, increasing the system IO pressure. tmp_table_size = 134217728
max_heap_table_size = 134217728
#Disable MySQL's cache query result set function #Decide whether to enable it based on business situation tests later #In most cases, turn off the following two items query_cache_size = 0
query_cache_type = 0
#Database error log file log_error = error.log
#Slow query sql log setting slow_query_log = 1
slow_query_log_file = slow.log
#Check the sql that does not use the index
log_queries_not_using_indexes = 1
#After log_queries_not_using_indexes is turned on, the frequency of slow SQL and the number of records per minute are recorded log_throttle_queries_not_using_indexes = 5
#Effective when used as a slave. Any slow SQL statements in slave replication will also be recorded. log_slow_slave_statements = 1
#The number of seconds that the slow query executes. This value must be reached to be recorded long_query_time = 8
#The number of rows retrieved must reach this value to be marked as a slow query min_examined_row_limit = 100
#mysql binlog log file expiration time, automatically deleted after expiration expire_logs_days = 5