Shulou(Shulou.com)06/01 Report--

CentOS7.4 system Information

[root@localhost iso] # uname-a

Linux localhost.localdomain 3.10.0-693.el7.x86_64 # 1 SMP Tue Aug 22 21:09:27 UTC 2017 x86'64 GNU/Linux

[root@localhost iso] # cat / etc/redhat-release

CentOS Linux release 7.4.1708 (Core)

Download address of rpm package for mysql

Https://dev.mysql.com/downloads/mysql/5.7.html#downloads

Mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar

Uninstall the mariadb that comes with the CentOS7.4 system

Copy mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar to / tmp and decompress it

Tar xvf mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar

After decompression is as follows

3. Install mysql-community-common-5.7.24-1.el7.x86_64.rpm, mysql-community-libs-5.7.24-1.el7.x86_64.rpm, mysql-community-client-5.7.24-1.el7.x86_64.rpm, mysql-community-server-5.7.24-1.el7.x86_64.rpm in turn

3.1 install common

3.2 install libs

3. 3 install client

3.4 install server, error, lack of dependency

3.5. resolve the problem of lack of dependencies when installing server

3.5.1 Mount the system iso image of CentOS7.4

Under / mnt, mkdir iso cdrom, transfer CentOS-7.4-x86_64-DVD-1708.iso to / mnt/iso

Mounting

3.5.2 create a local yum source with CentOS7.4 's system iso image (CentOS7.4 comes with yum installed)

View yum installation information

Back up the yum configuration file under / etc/yum.repos.d/

Create a bendi.repo file and edit and save

Clean up yum configuration

Cache the yum source locally to speed up the software search and installation

3.5.3 install perl dependencies

3.5.4 install net-tools dependency

3.6 successful installation of server

Note: sometimes it is necessary to restart the system to start the mysql service.

4. Check the status of port 3306. Exception

Fifth, firewall shutdown processing, view port 3306

5.1 turn off the firewall and confirm that the firewall is off

5.2 prevent the firewall from booting

5.3View port 3306, normal

6. Set the expiration date of database log to 7 days

Change the root user password of mysql and set it to allow root to log in remotely.

7.1get the initial password of the root user for mysql

7.2to obtain the initial password for the root user of mysql to log in to the database

7.3Modification of root password

7.4 make the password effective immediately

7.5 allow remote login to mysql as root

Change the character set of mysql to utf8

Edit the file / etc/my.conf and set the character set to utf8

Restart the mysql service

IX. Login effect of Navicat for MySQL

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.