CentOS8 install MySQL8.0

Install MySQL8.0#

Install MySQL using the latest package manager

Copy

sudo dnf install@mysql

Turn on boot#

After the installation is complete, run the following command to start the MySQL service and make it start automatically at startup:

Copy

sudo systemctl enable --now mysqld

To check whether the MySQL server is running, enter:

Copy

sudo systemctl status mysqld

Add password and security settings#

Run the mysql_secure_installation script, which performs some security-related operations and sets the MySQL root password:

Copy

sudo mysql_secure_installation

Proceed as follows:

You are required to configure the VALIDATE PASSWORD component: Enter y and press Enter to enter the configuration

Select the password verification strategy level, I choose 0 (low) here, press Enter
Enter new password twice
Confirm whether to continue using the provided password? Type y and press enter
Remove anonymous users? Type y and press enter
Do not allow root remote login? I need to log in remotely, so enter n and press Enter

Remove the test database? Type y and press enter
Reload the permission table? Type y and press enter

Remote login#

If you need to set up root account remote login, mysql statement:

Copy

use mysql; update``user``set host='%'``where``user='root'; flush``privileges;

Firewall settings#

After the setting is complete, open the system's 3306 port:

Copy

sudo firewall-cmd --add-port=3306/tcp --permanent sudo firewall-cmd --reload

Close MySQL host query dns#

MySQL will reversely resolve the dns record of the remote connection address. If the MySQL host cannot connect to the external network, the dns may not be resolved successfully, resulting in a slow connection to MySQL for the first time, so this function can be turned off in the configuration.
Reference Document
Open the /etc/my.cnf file and add the following configuration:

Copy

[ mysqld]``skip-name-resolve

Restart service#

Copy

sudo systemctl restart mysqld

After the test and installation of this machine, MySQL8.0 is already utf8mb4 character set by default, so the character set will not be modified