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

Find and delete mariadb

Rpm-qa | grep mariadb

Rpm-e-nodeps mariadb-libs

Download mysql-5.7.24-1.el7.x86_64.rpm-bundle.rar and upload it to the server home directory

Create a mysql folder under home, and extract the tar package to the mysql folder

Mkdir mysql

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

Enter the mysql folder and execute the following installation commands sequentially to ensure the success of each command (if there is a lack of dependencies during the period, download and install rpm dependencies first, and then execute the commands. )

Rpm-ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm

Rpm-ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm

Rpm-ivh mysql-community-devel-5.7.24-1.el7.x86_64.rpm

Rpm-ivh mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm

Rpm-ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm

Rpm-ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm

Start the mysql service and check whether the startup is successful. (reboot server if necessary. )

Systemctl start mysqld

Systemctl status mysqld

Check the initial root password of mysql

Grep 'temporary password' / var/log/mysqld.log

Log in to the database with the initial root password

Mysql-uroot-p

Change mysql's root login password and set remote login permissions

SET PASSWORD FOR 'root'@'localhost' = "Adm-12345"

GRANT ALL PRIVILEGES ON. TO 'root'@'%' IDENTIFIED BY' Adm-12345' WITH GRANT OPTION

FLUSH PRIVILEGES

9. Set port 3306 through the firewall

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

Firewall-cmd-reload

Attached:

View the installation path of mysql

Whereis mysql

View the version of mysql

Mysql-V

Mysql-version

Mysql-- help | grep Distrib

View the installation package version of mysql

Rpm-qa | grep mysql

Remote login command: mysql-h ip address-u root-P port number-p

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.