mysql安全设置

发布时间 2023-08-16 16:17:31作者: 昵称昵称昵称

## security setting
plugin-load-add = connection_control.so
connection-control = FORCE
connection-control-failed-login-attempts = FORCE
connection_control_min_connection_delay = 3600000
connection_control_max_connection_delay = 3600000
connection_control_failed_connections_threshold = 5

 

修改my.cnf限制登录失败次数为5次connection-control-failed-connections-threshold=5,并限制重试时间为60分钟connection-control-min-connection-delay=3600000,修改my.cnf配置,禁用local-infile选项;