Block wp-login and xmlrpc brute force attacks with CSF / DirectAdmin

BillyS said:
What database version are you using?
Click to expand...
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20942969
Server version: 5.7.37-cll-lve MySQL Community Server - (GPL)
 
oh.. just dont add: innodb_log_file_size=256M to config, all other can be added after mysql stopped.
 
Zhenyapan said:
dont add:
Click to expand...
this is my file for now is it okay ?

[mysqld] max_allowed_packet = 64M local-infile = 0 innodb_file_per_table sql_mode= STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION max_connections=200 wait_timeout=60 interactive_timeout=60 skip-name-resolve=1 tmp_table_size=256M max_heap_table_size=256M table_definition_cache=25000 key_buffer_size=8M innodb_buffer_pool_size=6G

do i have to restart mysql now ? or anything i have to restart ? like DA or any other service ?
 
Maybe it's better to create a new thread if more is done here, because it's getting a bit off-topic. Unless it's almost ready. ;)
 
Zhenyapan said:
yes
Click to expand...
Thank You very much, should i create a new thread for optimization ? we will discuss my server load i bet it will be very useful for everyone if you participate let me know

thank You
 
You must log in or register to reply here.
Back
Top