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

How to start a transaction in MySQL

Preface This article mainly introduces how to sta...

25 CSS frameworks, tools, software and templates shared

Sprite Cow download CSS Lint download Prefixr dow...

Vue uses custom instructions to add watermarks to the bottom of the page

Project Scenario Add a custom watermark to the en...

An example of how to write a big sun weather icon in pure CSS

Effect The effect diagram is as follows Implement...

nginx solves the problem of slow image display and incomplete download

Written in front Recently, a reader told me that ...

How to implement communication between Docker containers

Scenario: A laradock development environment (php...

An article to give you a deep understanding of Mysql triggers

Table of contents 1. When inserting or modifying ...

Specific use of ES6 array copy and fill methods copyWithin() and fill()

Table of contents Batch copy copyWithin() Fill ar...

Recommend a cool flashing alarm button

The effect is as follows: The code is as follows ...

MySQL paging performance exploration

Several common paging methods: 1. Escalator metho...

The difference between ID and Name attributes of HTML elements

Today I am a little confused about <a href=&quo...

CSS to achieve Skeleton Screen effect

When loading network data, in order to improve th...

UTF-8 and GB2312 web encoding

Recently, many students have asked me about web p...