Install

dnf install -y mysql-server

Set startup on startup

# View the running status of mysql-serversystemctl status mysqld# In order to avoid the interference of the firewall, in the development environment, we usually turn off the linux firewallsystemctl disable firewalld --now# rm -rf /var/lib/mysql/*# Set mysql-server to start at boot and start immediatelysystemctl enable mysqld --now # Wait patiently for a while

View root initial password

# View the root initial password in the startup log:grep "password" /var/log/mysql/mysqld.logYou will see information similar to the following...is created with an empty password !Initially, the root account password of MySQL Server is blank.

Change default root password

Use the root initial password to connect to mysql-server, for example:mysql -u root -pEnter password: mysql 8.0.26 has no default requirements for password security;MySQL 8.0.29 requires uppercase and lowercase alphanumerics and special characters by default, and the length must be more than 8 digits.Enter the following SQL statement to change the root initial password to a custom password:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'write new password here';

Release remote login restrictions for root account

USE mysql;UPDATE `user` SET `host` = '%' where `user` = 'root' AND `host` = 'localhost';FLUSH PRIVILEGES;exit;Authenticate: Log in with a new password after logging out.

Reduce password security requirements, reset root password again

• Note: Configuration can only be done after resetting the initial root password.

Step 1: View and modify related configuration items:SHOW VARIABLES LIKE 'validate_password%';set global validate_password.policy=0;set global validate_password.length=4;SHOW VARIABLES LIKE 'validate_password%';Step 2: Reset root password, reset to simple password:ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';