Centos7 installs MySQL 5.7 through Yum and enables remote access

Preface

Mysql We all understand , I just want to make more introductions , Go straight ahead mysql Installation of , The following records if it passes yum install mysql5.7, This method is also applicable to installation 8.0,5.6,5.5 etc. mysql edition

Text

1. Delete mariadb

centos7 By default... Will be installed mysql Another branch version of mariadb, In the installation mysql front , It needs to be deleted

#  Find out mariadb Of rpm package 
$ rpm -qa|grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64

#  Ignore dependencies , Delete this package 
$ rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

 2. Add official yum Source and install mysql

visit mysql official yum Source download address , Select the system , Click to download , Enter the page , Copy download connection

#  Download and install this yum Warehouse 
$ rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

#  After installation , this yum By default, the source warehouse is installed mysql The latest version 8.0 edition .
#  We need to modify the following items in the document , Make it download 5.7 edition , If you want to install another version , Open the corresponding version , Close other versions .
$ vim /etc/yum.repos.d/mysql-community.repo
----------------------------------------------------------------
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1    #  There will be 0 Change it to 1, Turn on 5.7 edition 
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/
enabled=0    #  There will be 1 Change it to 0, close 8.0 edition 
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
----------------------------------------------------------------

#  After the modification is completed , install mysql5.7
$ yum install -y mysql-community-server

After installation , The configuration file is /etc/my.cnf Configure according to the actual situation .

3. Start the service , Turn on Remote Access

#  start-up mysql service 
$ systemctl start mysqld

#  Set to enable self start 
$ systemctl enable mysqld

#  First boot mysql after , An initial password will be automatically generated in the log file , The default log file path is ：/var/log/mysqld.log
#  Find the initialization password 
$ cat /var/log/mysqld.log |grep password
2019-06-18T12:12:04.161088Z 1 [Note] A temporary password is generated for [email protected]: 2%w)IDysCVZQ

#  The password here is the one output above , Use this password to log in mysql
$ mysql -u root -p 
#  Copy password output , Get into mysql
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.26

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> 

#  Change Password ,mysql5.7 The default password strength of is very high , Case is required , Symbols and numbers , Longer than 6, Be short of one cannot 
mysql> alter user 'root'@'localhost' identified by 'your_password';
Query OK, 0 rows affected (0.00 sec)

#  If you don't want such a complicated password , Change the password strength to the minimum , That is, only judge the password length 
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

#  Turn on Remote Access 
$ grant all privileges on *.* to 'root'@'%' identified by 'your_password';
Query OK, 0 rows affected, 1 warning (0.00 sec)

#  Refresh permissions take effect 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)



#  That's it mysql The initial setting of , Now you can use your account and password , Visit this mysql Yes 
#  Don't forget to open the database before accessing 3306 port 
$ firewall-cmd --add-port=3306/tcp --permanent
$ firewall-cmd --reload

end

ok, It's so simple mysql5.7 Of yum install , Through this method, you can also install mysql5.5,5.6,8.0 These versions . As long as the official yum Warehouse support is ok , Very simple and convenient .