Install MySQL database in Centos7

Install MySQL database in Centos7

Before that, there was a blog that was manually compiled and installed in the REDHAD6 MySQL database below describes another in the CENTOS7 with the Yum Warehouse online installation MySQL database

1. Preparation environment

2. Select Nat mode in the virtual machine (because you need to download the installation source online)

3. Be able to surf the internet

------------------------Yun to install the MySQL database online-----------------------------

Download and install the official MySQL Yum Repository

Use the command above to download the installation of Yum Repository, about 25KB, then you can directly install Yum

Start installation

The previous mariadb will be overwritten when the installation is complete.

has been installed

As dependencies are installed

Alternative

Complete!

Here are some configuration settings for MySQL

Open service

View open status with status

Open success

Use Mysql-uroot-p to enter the database this will display a password, this password and then mysql.log log file in the first check the password

Filter log file password

Last line [email protected]: followed by MySQL database access password

Then use the Mysql-uroot-p to enter the database into the log file password

After entering, some settings need to be set "reset MySQL password" by:

Can see the length of my password is the number of its database password to have English, digital, special symbol composition

How do you set the password length by:

This command is equal to the number that follows is the length of the password set.

Then use the above command to set the password when displayed

Show as Password set success

------------------several ways to set passwords and view password combinations----------------------------

1: Use Set password command

2: With Mysqladmin

3: With Update

4: When you forget the root password, you can

To view the specific requirements for setting a password

will see the following:

Parameter explanation:

1. Validate_password_dictionary_file the file path of the specified password authentication;
2. Validate_password_length Minimum Password length
3. Validate_password_mixed_case_count password must contain at least the number of lowercase letters and the number of capital letters;
4. Validate_password_number_count the number of digits that the password must contain at least
5. Validate_password_policy Password strength check level, the corresponding level is: 0/low, 1/medium, 2/strong, the default is 1.

Installing the MySQL database with Yum It's very quick to think it's helping you. Please leave your footprints if you have insufficient points

Install MySQL database in Centos7