Installation of MySQL after CentOS 7 minimized installation

2. Start the network card
   1. Verifying network manager and NIC interface status

      # SYSTEMCTL Status Networkmanager.service

      # NMCLI Dev Status

   2. Modifying the network card configuration file

      From the previous step you can see that there are two network card devices, eno16777984 and lo, in/etc/sysconfig/network-scripts to find files ending in eno16777984, to get ifcfg-eno16777984 files.

      # VI ifcfg-eno16777984

      #: X

      Save exit

   3. Start the network, activate the NIC

      #/etc/init.d/network start/start NIC

      # ifup Etho/Activate NIC

      # NMCLI Device status/view network connection Status

4. Copy rpm to Server

   WINSCP, copy rpm from local Windows machine to remote server, including MySQL and Net-tools

6. Install MySQL

   # RPM–IVH net-tools.rpm

   # RPM–IVH mysql.rpm

   Lib in MySQL conflicts with Lib in mariadb, while Postfix relies on mysql-client in mariadb, uninstalls Postfix and Mariadb-libs

   # rpm–e postfix.rpm

   # rpm–e mariadb-libs.rpm

   # RPM–IVH mysql.rpm mysql-client.rpm

1. Log in to MySQL for the first time and set MySQL to be accessible from anywhere

   # service MySQL Start

   # mysql–u Root–p (Enter password after carriage return, recommended to copy from. mysql_secret file, hand-made error prone)

   mysql> Set Password = password ("123456")

   Mysql> exit;

   # mysql–u root–p (enter new password after entering 123456)

   Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT option;

   mysql> flush Privileges;

   # Systemctl Start Firewalld.service/start firewall

   # Systemctl Stop firewalld.service/Stop firewall

   # systemctl Disable Firewalld.service/disable firewall boot boot

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

   # Firewall-cmd–reload/Reload to take effect

2. Remotely log in to MySQL using Navicat

Installation of MySQL after CentOS 7 minimized installation