Detailed tutorial for installing mysql5.7.18 on centos7.3

Detailed tutorial for installing mysql5.7.18 on centos7.3

1 Check the Linux distribution version

[root@typecodes ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)

2 Download the official MySQL Yum Repository

According to the Linux distribution version (CentOS and Fedora both belong to Red Hat), obtain the Yum Repository from the MySQL official website (http://dev.mysql.com/downloads/repo/yum/).

[root@typecodes ~]# wget -i http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
--2016-02-03 18:36:02-- http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm [following]
--2016-02-03 18:36:04-- http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 104.102.164.25
Connecting to repo.mysql.com (repo.mysql.com)|104.102.164.25|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 8984 (8.8K) [application/x-redhat-package-manager]
Saving to: 'mysql57-community-release-el7-7.noarch.rpm'
100%[===================================================================================================================================================>] 8,984 --.-K/s in 0s
2016-02-03 18:36:07 (68.4 MB/s) - 'mysql57-community-release-el7-7.noarch.rpm' saved [8984/8984]
3 Install MySQL Yum Repository
After installing the MySQL Yum Repository, each execution of yum update will check whether MySQL is updated.
[root@typecodes ~]# yum -y install mysql57-community-release-el7-7.noarch.rpm
Loaded plugins: axelget, fastestmirror, langpacks
Examining mysql57-community-release-el7-7.noarch.rpm: mysql57-community-release-el7-7.noarch
Marking mysql57-community-release-el7-7.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql57-community-release.noarch 0:el7-7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=======================================================================================================================================================================
 Package Arch Version Repository Size
=======================================================================================================================================================================
Installing:
 mysql57-community-release noarch el7-7 /mysql57-community-release-el7-7.noarch 7.8 k
Transaction Summary
=======================================================================================================================================================================
Install 1 Package
Total size: 7.8 k
Installed size: 7.8 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing:mysql57-community-release-el7-7.noarch 1/1 
 Verifying : mysql57-community-release-el7-7.noarch 1/1
Installed:
 mysql57-community-release.noarch 0:el7-7
Complete!

3 Install the server version of the MySQL database

[root@typecodes ~]# yum -y install mysql-community-server
Loaded plugins: axelget, fastestmirror, langpacks
No metadata available for base
No metadata available for epel
No metadata available for extras
repomd.xml | 2.5 kB 00:00:00  
update mysql-connectors-community metadata successfully
repomd.xml | 2.5 kB 00:00:00  
update mysql-tools-community metadata successfully
repomd.xml | 2.5 kB 00:00:00  
update mysql57-community metadata successfully
No metadata available for updates
mysql-connectors-community | 2.5 kB 00:00:00  
mysql-tools-community | 2.5 kB 00:00:00  
mysql57-community | 2.5 kB 00:00:00  
(1/3): mysql-tools-community/x86_64/primary_db | 24 kB 00:00:01  
(2/3): mysql57-community/x86_64/primary_db | 28 kB 00:00:01  
(3/3): mysql-connectors-community/x86_64/primary_db | 8.6 kB 00:00:02  
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * epel: mirrors.neusoft.edu.cn
 * extras: mirrors.163.com
 * updates: mirrors.163.com
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.10-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.7.10-1.el7 for package: mysql-community-server-5.7.10-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.10-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.10-1.el7 for package: mysql-community-client-5.7.10-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.10-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.44-2.el7.centos will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.10-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.10-1.el7 will be obsoleting
--> Finished Dependency Resolution
Dependencies Resolved
=======================================================================================================================================================================
 Package Arch Version Repository Size
=======================================================================================================================================================================
Installing:
 mysql-community-libs x86_64 5.7.10-1.el7 mysql57-community 2.2 M
  replacing mariadb-libs.x86_64 1:5.5.44-2.el7.centos
 mysql-community-libs-compat x86_64 5.7.10-1.el7 mysql57-community 2.0 M
  replacing mariadb-libs.x86_64 1:5.5.44-2.el7.centos
 mysql-community-server x86_64 5.7.10-1.el7 mysql57-community 142 M
Installing for dependencies:
 mysql-community-client x86_64 5.7.10-1.el7 mysql57-community 24 M
 mysql-community-common x86_64 5.7.10-1.el7 mysql57-community 269 k
Transaction Summary
=======================================================================================================================================================================
Install 3 Packages (+2 Dependent packages)
Total download size: 171 M
Downloading packages:
mysql-community-server-5.7.10-1.el7.x86_64.rpm | 142 MB 00:03:42  
mysql-community-libs-compat-5.7.10-1.el7.x86_64.rpm | 2.0 MB 00:00:03  
mysql-community-libs-5.7.10-1.el7.x86_64.rpm | 2.2 MB 00:00:05  
mysql-community-client-5.7.10-1.el7.x86_64.rpm | 24 MB 00:00:41  
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.10-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY00 ETA 
Public key for mysql-community-common-5.7.10-1.el7.x86_64.rpm is not installed
mysql-community-common-5.7.10-1.el7.x86_64.rpm | 269 kB 00:00:01  
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid : "MySQL Release Engineering <[email protected]>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package : mysql57-community-release-el7-7.noarch (@/mysql57-community-release-el7-7.noarch)
 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing: mysql-community-common-5.7.10-1.el7.x86_64 1/6 
 Installing: mysql-community-libs-5.7.10-1.el7.x86_64 2/6 
 Installing: mysql-community-client-5.7.10-1.el7.x86_64 3/6 
 Installing: mysql-community-server-5.7.10-1.el7.x86_64 4/6 
 Installing: mysql-community-libs-compat-5.7.10-1.el7.x86_64 5/6 
 Erasing : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 6/6 
 Verifying: mysql-community-server-5.7.10-1.el7.x86_64 1/6 
 Verifying : mysql-community-libs-compat-5.7.10-1.el7.x86_64 2/6 
 Verifying : mysql-community-common-5.7.10-1.el7.x86_64 3/6 
 Verifying : mysql-community-libs-5.7.10-1.el7.x86_64 4/6 
 Verifying : mysql-community-client-5.7.10-1.el7.x86_64 5/6 
 Verifying : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 6/6
Installed:
 mysql-community-libs.x86_64 0:5.7.10-1.el7 mysql-community-libs-compat.x86_64 0:5.7.10-1.el7 mysql-community-server.x86_64 0:5.7.10-1.el7
Dependency Installed:
 mysql-community-client.x86_64 0:5.7.10-1.el7 mysql-community-common.x86_64 0:5.7.10-1.el7
Replaced:
 mariadb-libs.x86_64 1:5.5.44-2.el7.centos
Complete!
[root@typecodes ~]# clear

Final screenshots:

yum安裝mysql5.7.10

4 Start the database:

[root@typecodes ~]# systemctl start mysqld.service

Then use the command systemctl status mysqld.service to view the service status after the MySQL database is started:

systemctl命令查看MySQL服務狀態

5 Obtain the initial password

After installing and starting the MySQL service using YUM, the MySQL process will automatically print the initial password of the root user in the process log:

########Get the initial password of the root user from the mysql process log: ra%yk7urCBIh
[root@typecodes ~]# grep "password" /var/log/mysqld.log
2016-02-03T10:42:17.272166Z 1 [Note] A temporary password is generated for root@localhost: ra%yk7urCBIh
2016-02-03T10:42:36.776875Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:42:52.063138Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:42:57.564373Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:43:01.477007Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:46:03.642008Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:46:11.217889Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:47:44.755199Z 0 [Note] Shutting down plugin 'validate_password'
2016-02-03T10:47:46.505844Z 0 [Note] Shutting down plugin 'sha256_password'
2016-02-03T10:47:46.505851Z 0 [Note] Shutting down plugin 'mysql_native_password'

6 Change the root user password

Use the initial password of the root user obtained in Section 5, and then modify it:

set global validate_password_policy =0 ; //The default is 1, which is MEDIUM, so the password you set at the beginning must meet the length requirements and must contain numbers, lowercase or uppercase letters, and special characters.

set global validate_password_length=4; //Specifies the length of the data in the password alter user root@localhost identified by 'crow'; //Change password

Add remote access permissions

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'crow' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Exit mysql and restart the service

systemctl restart mysqld

Open port 3306 on the firewall

firewall-cmd --zone=public --add-port=3306/tcp --permanent

Restart the firewall

firewall-cmd --reload
[root@typecodes ~]# mysql -uroot -p
Enter password: #######Enter the default root password and press Enter Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.10
Copyright (c) 2000, 2015, 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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye

7 Installation Complete

At this point, the installation of the MySQL 5.7.10 database using the YUM method in CentOS 7 is complete. As shown below, you can log in to MySQL using the new root password.

[root@typecodes ~]# mysql -uroot -ppassword
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 3
Server version: 5.7.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, 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> 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
|mysql |
| performance_schema |
|sys|
+--------------------+
4 rows in set (0.00 sec)
mysql> clear
mysql> exit
Bye
[root@typecodes ~]# clear

Appendix 1: View the configuration information of the MySQL database

The MySQL configuration file is still /etc/my.cnf. Other installation information can be viewed through the mysql_config command. Among them, the dynamic library files are stored in the /usr/lib64/mysql directory.

mysql_config命令查看mysql數據庫的安裝信息

Appendix 2: For C/C++ developers

Since header files such as mysql.h are needed, you need to execute the following command to install the mysql development version.

[root@typecodes ~]# yum -y install mysql-community-devel

Appendix 3: Deleting the MySQL Repository

Because the MySQL Yum Repository was installed in Section 3, each subsequent yum operation will check for updates. If you want to remove this automatic check operation, you can use the following command to uninstall the MySQL Repository.

[root@typecodes ~]# yum -y remove mysql57-community-release-el7-7.noarch
update 2017.04.10 11:10

You can also use the above yum method to install the latest version mysql5.7.18 on the mysql official website. Just replace the version of the rmp package in Section 2, and the subsequent steps remain unchanged.

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

The above is a detailed tutorial on how to install mysql5.7.18 on centos7.3 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • Linux learning third Centos7 installation mysql5.7.16 database
  • How to install and modify the initial password of mysql5.7.18 under Centos7.3
  • Centos7 installation and configuration of Mysql5.7
  • Tutorial on installing lnmp using yum on centos7 (linux+nginx+php7.1+mysql5.7)
  • A concise tutorial on how to install mysql5.7 decompressed version on CentOS7
  • Detailed steps to install Mysql5.7.19 using yum on Centos7
  • Detailed tutorial on installing Mysql5.7.19 on Centos7 under Linux
  • Alibaba Cloud Centos7.3 installation mysql5.7.18 rpm installation tutorial
  • Installation and configuration code of apache, php7 and mysql5.7 in CentOS7 server
  • Detailed explanation of how to install mysql5.7.16 from source code in centos7 environment

<<:  Linux kernel device driver virtual file system notes

>>:  Detailed explanation of how to solve the circular reference problem encountered when using JSON.stringify

Recommend

How to implement mobile web page size adaptation

I finally finished the project at hand, and the m...

Docker network principles and detailed analysis of custom networks

Docker virtualizes a bridge on the host machine. ...

Solution to the problem that the MySQL configuration file cannot be modified (Win10)

Record the problems you solve for others. Problem...

Detailed explanation of how to install MariaDB 10.2.4 on CentOS7

CentOS 6 and earlier versions provide MySQL serve...

15-minute parallel artifact GNU Parallel Getting Started Guide

GNU Parallel is a shell tool for executing comput...

You may need a large-screen digital scrolling effect like this

The large-screen digital scrolling effect comes f...

JS Decorator Pattern and TypeScript Decorators

Table of contents Introduction to the Decorator P...

How to manage users and groups when running Docker

Docker is a management tool that uses processes a...

Solution to the failure of loading dynamic library when Linux program is running

Unable to load dynamic library under Linux When t...

Complete steps for deploying a front-end and back-end separated nginx configuration

Preface It's a cliché. Here I will talk about...

CSS commonly used font style to set the font of a variety of changes (example detailed explanation)

CSS font properties define the font family, size,...

Problems and solutions when replacing Oracle with MySQL

Table of contents Migration Tools Application tra...

ffmpeg Chinese parameter description and usage examples

1. When ffmpeg pushes video files, the encoding f...

Ideas and methods for incremental backup of MySQL database

To perform incremental backup of the MySQL databa...

How to find and delete duplicate rows in MySQL

Table of contents 1. How to find duplicate rows 2...