Change database column utf-8

Zip All files in current directory
zip -r foo.zip .

Replace †Â
UPDATE tablename SET colname= CONVERT(BINARY CONVERT(colname USING latin1) USING utf8)

Replace js hacked wordpress
update wp2p_posts set post_content = replace(post_content,"<script src='https://track.greengoplatform.com/smile.js?v=3.3.9' type='text/javascript'></script>",'');

Check ukuran Folder mana yang paling besar
du -hsx * | sort -rh | head -10

Menghitung size folder
du -sh /namafolder

cari text dalam file
grep -Ril "if(ndsw===undefined)" /home

cari file dalam folder
find /home -name 2index.php

script untuk chmod folder dan files
buat file changemod di /usr/local/sbin
#!/bin/bash
find $1 -type d -print0 | xargs -0 chmod $2

find $1 -type f -print0 | xargs -0 chmod $3
#find $1 -type d -print0

ubah supaya bisa di execution dengan perintah chmod +x changemod
cara menjalankannya : changemod /home 755 644 (555 444)

=======================
Ubah domain URL Wordpress :
Perhatikan table prefix

UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

======================
Tutorial Fail2ban blocking Bad Bots
https://www.booleanworld.com/blocking-bad-bots-fail2ban/

======================
hestiacp
password root = grep --color=always PASSWORD /usr/local/hestia/conf/mysql.conf