MySQL关闭密码强度验证功能
关于密码强度验证：
[root@mysqlmysql]#mysql-uroot-p123456
mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis4
Serverversion:5.7.18
Copyright(c)2000,2017,Oracleand/oritsaffiliates.Allrightsreserved.
OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.
Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.
mysql>
mysql>
mysql>usemysql
ERROR1820(HY000):YoumustresetyourpasswordusingALTERUSERstatementbeforeexecutingthisstatement.
mysql>SETPASSWORD=PASSWORD('');
ERROR1819(HY000):Yourpassworddoesnotsatisfythecurrentpolicyrequirements
mysql>exit
Bye
[root@mysqlmysql]#
[root@mysqlmysql]#
[root@mysqlmysql]#vi/etc/my.cnf
#Foradviceonhowtochangesettingspleasesee
#http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
#Removeleading#andsettotheamountofRAMforthemostimportantdata
#cacheinMySQL.Startat70%oftotalRAMfordedicatedserver,else10%.
#innodb_buffer_pool_size=128M
#
#Removeleading#toturnonaveryimportantdataintegrityoption:logging
#changestothebinarylogbetweenbackups.
#log_bin
#
#Removeleading#tosetoptionsmainlyusefulforreportingservers.
#TheserverdefaultsarefasterfortransactionsandfastSELECTs.
#Adjustsizesasneeded,experimenttofindtheoptimalvalues.
#join_buffer_size=128M
#sort_buffer_size=2M
#read_rnd_buffer_size=2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityrisks
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,1016Cwritten
[root@mysqlmysql]#servicemysqldrestart
Stoppingmysqld:[OK]
Startingmysqld:[OK]
[root@mysqlmysql]#mysql-uroot-p123456
mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis4
Serverversion:5.7.18
Copyright(c)2000,2017,Oracleand/oritsaffiliates.Allrightsreserved.
OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.
Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.
mysql>
mysql>
mysql>usemysql
ERROR1820(HY000):YoumustresetyourpasswordusingALTERUSERstatementbeforeexecutingthisstatement.
mysql>SETPASSWORD=PASSWORD('');
QueryOK,0rowsaffected,1warning(0.00sec)
mysql>
以上所述是小编给大家介绍的MySQL关闭密码强度验证功能，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！