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

This article will explain in detail how to use the dnf method to install mysql in CentOS7, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

1. Install mysql's yum repository

Execute the following command:

Yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

two。 Install mysql

Dnf install mysql-community-server

3. Enable the mysql service

Service mysql start

4. Find the default password

To enhance security, MySQL5.7 randomly generates a password for root users, and in error log, with regard to the location of error log, the default is / var/log/mysqld.log if the RPM package is installed.

You can view the temporary password only after starting mysql once. Enter the following command to view the password:

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

The output is as follows:

[root@VM_0_13_centos init.d] # grep 'temporary password' / var/log/mysqld.log

2018-03-09T13:03:32.859149Z 1 [Note] A temporary password is generated for root@localhost: IVXhn:4E3uQ4

5. Log in to mysql and change your password

ALTER USER 'root'@'localhost' IDENTIFIED BY' root123'

If you change the password, it will appear:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Two global parameters must be modified:

First, modify the value of the validate_password_policy parameter

Set global validate_password_policy=0

Then change the length of the password

Set global validate_password_length=1

Just change the password again.

ALTER USER 'root'@'localhost' IDENTIFIED BY' root123'

6. Authorize other machines to connect

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' passwort' WITH GRANT OPTION; / / passwort change to mysql login password FLUSH PRIVILEGES; about how to use the dnf method in CentOS7 to install mysql. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.