How to cancel password strength verification in MySql

1. Modify the MySql configuration file (my.cnf)

Recommended related mysql video tutorials: "mysql tutorial"

Generally, the MySql configuration file my.cnf will be in the /etc/ directory. If not, you can use the following command to find the location:

$ sudo find / -name my.cnf

Edit the configuration file:

$ sudo vi /etc/my.cnf

Add the following content at the end of the file:

plugin-load=validate_password.so 
validate-password=OFF

Save and exit

2. Restart the mysqld service

Restart the service to make the configuration file take effect:

$ sudo service mysqld restart

3. Log in to mysql to verify

Use the command to log in to verify whether the configuration file is valid:

$ mysql -u用户名 -p密码

Feel free to change it to a simple password and check whether it is successful. The command will not be written out

The above is the detailed content of How to cancel password strength verification in MySql. For more information, please follow other related articles on the PHP Chinese website!