Linux installation MySQL 5.7.21 detailed and troubleshooting problems encountered during installation

The problems encountered during the installation process are:
1. my-default.cnf File not found
2. mysql Start error
3. mysql temporary password cannot be logged in

Installation Environment CentOS 6.0
Download the database:
[Email protected] src]# pwd
/USR/LOCAL/SRC #下载文件存放路径 (for personal reasons, be free.) ）
[Email protected] src]#
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
[Email protected] src]# TAR-ZXVF mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz #解压
[[Email protected] src]# mv mysql-5.7.21-linux-glibc2.12-x86_64 MySQL
#更改文件名
To uninstall an older version:
[[email protected] src]# rpm-qa |grep MySQL
Mysql-5.1.47-4.el6.x86_64
Mysql-libs-5.1.47-4.el6.x86_64
Mysql-devel-5.1.47-4.el6.x86_64
[Email protected] src]# rpm-e--nodeps mysql-5.1.47-4.el6.x86_64
[Email protected] src]# rpm-e--nodeps mysql-libs-5.1.47-4.el6.x86_64
[Email protected] src]# rpm-e--nodeps mysql-devel-5.1.47-4.el6.x86_64
[[email protected] src]# rpm-qa |grep MySQL
[Email protected] src]#

CREATE database directories and users and groups:
[[email protected] src] #mkdir/data
[[email protected] src] #mkdir/data/mysqldata #数据存放目录
[[email protected] src] #groupadd mysql #创建mysql组
[[email protected] src] #useradd-r-s/sbin/nologin-g MySQL mysql-d/usr/local/src/mysql #添加mysql用户使其shell模式为nologin (Forbidden Login),
[[email protected] mysql]# chown-r MySQL.
[[email protected] mysql]# chgrp-r MySQL.
[[email protected] MySQL] #chown-R mysq/data/mysqldata
Install the Numactl component before installation, or error: Bin/mysqld:error while loading shared libraries:libnuma.so.1
[Email protected] mysql]# yum-y install Numactl
(You can install it using the local CD Yum source, provided that it is built.) ）
Configuration parameters:
[[Email protected] src]# CD MySQL
[Email protected] mysql]# bin/mysqld--initialize--user=mysql--basedir=/usr/local/src/mysql--datadir=/data/ mysqldata/#配置参数
2018-01-31t08:41:32.144065z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-01-31t08:41:34.501273z 0 [Warning] innodb:new log files created, lsn=45790
2018-01-31t08:41:34.943351z 0 [Warning] innodb:creating FOREIGN KEY constraint system tables.
2018-01-31t08:41:35.016168z 0 [Warning] No existing UUID have been found, so we assume that's the first time that thi s server has been started. Generating a new uuid:8b673fc1-0662-11e8-a70a-000c298536ba.
2018-01-31t08:41:35.021358z 0 [Warning] Gtid table is not a ready-to-be used. Table ' mysql.gtid_executed ' cannot be opened.
2018-01-31t08:41:35.025019z 1 [Note] A temporary password is generated for [email protected]: dhamrqavz5-c {last [email prot Ected]: After the temporary password (I did not feel during the installation process, login not.) )}
--basedir=/usr/local/src/mysql #mysql文件所在目录
--datadir=/data/mysqldata/#数据库存放目录

[Email protected] mysql]# Bin/mysql_ssl_rsa_setup--datadir=/data/mysqldata/
#配置参数

To modify the system configuration file:

The my-default.cnf file was not found in the Support-files directory, so it can only be created manually.
[[email protected] support-files]# vim/etc/my.cnf (Create MY.CNF, copy the following code, remember that the following directories need to manually modify their own defined directory)

[Client]
Port = 3306
Socket =/tmp/mysql.sock

[Mysqld]
Character_set_server=utf8
init_connect= ' SET NAMES UTF8 '
Basedir=/usr/local/src/mysql #文件存放目录
datadir=/data/mysqldata/#数据库存放目录
Socket=/usr/local/src/mysql/mysql.sock
Log-error=/var/log/mysqld.log
Pid-file=/var/run/mysqld/mysqld.pid
Lower_case_table_names = 1

Sql_mode=strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_user,no_ Engine_substitution
max_connections=5000

Default-time_zone = ' the ' "

[email protected] support-files]# CP Mysql.server/etc/init.d/mysql
[Email protected] support-files]# Vim/etc/init.d/mysql
Modify/etc/init.d/mysqld to fill in the file storage path and data storage path after Basedir and DataDir

start MySQL:
[Email protected] mysql]# bin/mysqld_safe--user=mysql & #检测

[[email protected] run]#/etc/init.d/mysql start (Error here, because the Mysqld folder cannot be found, so create and give permissions.) ）


[Email protected] mysql]# cd/var/run/
[Email protected] run]# mkdir mysqld
[Email protected] run]# chown-r MySQL mysqld
[Email protected] run]# chgrp-r MySQL mysqld
[[email protected] run]#/etc/init.d/mysql start
Starting MySQL ... [OK]

login MySQL has changed password:
Since the attempt to use the MySQL temporary password can not log in, so the following directly into the configuration.
Modify the/etc/my.cnf file
Add "Skip-grant-tables" below [mysqld]

(The Skip-grant-tables command is to skip authentication and log in directly.) Personally think of Linux as a single-user mode for MySQL password modification. ）
Restart MySQL

Enter MySQL on the command line to log in

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| MySQL |
| Performance_schema |
| SYS |
+--------------------+
4 rows in Set (0.00 sec)

mysql> use MySQL; #选择数据库
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed
mysql> Update user Set Authentication_string=password (' 123abc ') where user= ' root ';
Query OK, 0 rows affected, 1 Warning (0.00 sec)
Rows matched:1 changed:0 warnings:1

mysql> flush Privileges; #刷新权限
Query OK, 0 rows Affected (0.00 sec)

Mysql> quit;
Bye
Log back in to MySQL
[[email protected] run] #mysql-uroot-p123abc

The last step unregisters "Skip-grant-tables" in my.cnf

Linux installation MySQL 5.7.21 detailed and troubleshooting problems encountered during installation