MySQL关闭密码强度验证功能

2024-02-18 12:04:03 386

[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关闭密码强度验证功能

热门推荐

随机推荐