MySQL turns off password strength verification

MySQL turns off password strength verification

About password strength verification:

[root@mysql mysql]# mysql -uroot -p123456 
mysql: [Warning] Using a password on the command line interface can be insecure. 
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 4 
Server version: 5.7.18 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. 
Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
mysql>  
mysql>  
mysql> use mysql 
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 
mysql> SET PASSWORD = PASSWORD(''); 
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 
mysql> exit 
Bye 
[root@mysql mysql]#  
[root@mysql mysql]#  
[root@mysql mysql]# vi /etc/my.cnf 
# For advice on how to change settings please see 
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html 
[mysqld] 
# 
# Remove leading # and set to the amount of RAM for the most important data 
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
# innodb_buffer_pool_size = 128M 
# 
# Remove leading # to turn on a very important data integrity option: logging 
# changes to the binary log between backups. 
# log_bin 
# 
# Remove leading # to set options mainly useful for reporting servers. 
# The server defaults are faster for transactions and fast SELECTs. 
# Adjust sizes as needed, experiment to find the optimal values. 
# join_buffer_size = 128M 
# sort_buffer_size = 2M 
# read_rnd_buffer_size = 2M 
datadir=/var/lib/mysql 
socket=/var/lib/mysql/mysql.sock 
# Disabling symbolic-links is recommended to prevent assorted security risks 
symbolic-links=0 
log-error=/var/log/mysqld.log 
pid-file=/var/run/mysqld/mysqld.pid 
plugin-load=validate_password.so 
validate-password=OFF 
~ 
~ 
~ 
~ 
~ 
~ 
~ 
~ 
"/etc/my.cnf" 30L, 1016C written 
[root@mysql mysql]# service mysqld restart 
Stopping mysqld: [ OK ] 
Starting mysqld: [ OK ] 
[root@mysql mysql]# mysql -uroot -p123456 
mysql: [Warning] Using a password on the command line interface can be insecure. 
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 4 
Server version: 5.7.18 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. 
Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
mysql>  
mysql>  
mysql> use mysql 
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 
mysql> SET PASSWORD = PASSWORD(''); 
Query OK, 0 rows affected, 1 warning (0.00 sec) 
mysql>

The above is what I introduced to you about disabling the password strength verification function in MySQL. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • mysql-8.0.15-winx64 uses the zip package to install and the service is shut down immediately after starting
  • Perfect solution to the problem of MySQL shutting down immediately after startup (caused by ibdata1 file corruption)
  • How to disable foreign key constraint checking in MySQL child tables
  • How to open and close the MySQL database using mysqli object-oriented method in PHP
  • Tutorial on safely shutting down the MySQL service
  • How to turn off MySQL log to protect disk space under lnmp
  • Using batch processing to start and shut down mysql under Windows
  • How to open, close, and view function functions of MySQL database
  • Detailed explanation of MySQL shutdown process and methods to safely shut down MySQL
  • In-depth analysis of the definition, use and closing of Mysql cursors
  • Starting and shutting down the MySQL server
  • How to safely shut down a MySQL instance

<<:  Solution to Vue data assignment problem

>>:  How to install Chrome browser on CentOS 7

Recommend

MySQL character set viewing and modification tutorial

1. Check the character set 1. Check the MYSQL dat...

Ideas and codes for realizing magnifying glass effect in js

This article example shares the specific code of ...

A mobile adaptive web page effect solves the problem of small display page

For work needs, I need to make a mobile phone adap...

Summary of some practical little magic in Vue practice

How can you forget lazy loading of routes that al...

Analysis of the difference between emits and attrs in Vue3

Table of contents in conclusion Practice Analysis...

How to optimize MySQL query speed

In the previous chapters, we introduced how to ch...

Analysis of MySQL lock mechanism and usage

This article uses examples to illustrate the MySQ...

How to build ssh service based on golang image in docker

The following is the code for building an ssh ser...

How to use the Marquee tag in XHTML code

In the forum, I saw netizen jeanjean20 mentioned h...

Detailed explanation of Linux host name modification command

Linux change hostname command 1. If you only need...

How to improve MySQL Limit query performance

In MySQL database operations, we always hope to a...

Rainbow button style made with CSS3

Result: Implementation code: html <div class=&...

Gallery function implemented by native Js

Table of contents The first The second Native Js ...

vsCode generates vue templates with one click

1. Use the shortcut Ctrl + Shift + P to call out ...

W3C Tutorial (13): W3C WSDL Activities

Web Services are concerned with application-to-ap...