Запис завантажувальної флешки через DD

 

sudo dd bs=4M if=/path/to/iso/file of=/dev/sdb status=progress && sync

reset деяких залізяк Cisco

щоб надіслати break в Minicom, натискаємо Ctrl+a f

rommon 1 >confreg 0x2142
rommon 2 >reset

https://www.freeccnaworkbook.com/workbooks/ccna/cisco-2600-series-router-password-reset

reset pix: https://www.petenetlive.com/KB/Article/0000064

One more beautiful theme for Midnight Commander

https://draculatheme.com/midnight-commander

Clearing zabbix history via SQL

DELETE FROM history_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM history WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM trends_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM trends WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM events WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM alerts WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));

Видалення листів з черги

mailq | awk '$7~/@/{print$1}' | while read qid; do postsuper -d $qid; done

Вирішення помилки в mysql "Row Size Too Large" з InnoDB

[mysqld]

innodb_log_file_size = 512M
innodb_strict_mode = 0

mysql 8 зміна паролю з плагіном caching_sha2_password

SET GLOBAL validate_password.LENGTH = 4; 

SET GLOBAL validate_password.policy = 0; 

SET GLOBAL validate_password.mixed_case_count = 0; 

SET GLOBAL validate_password.number_count = 0; 

SET GLOBAL validate_password.special_char_count = 0; 

SET GLOBAL validate_password.check_user_name = 0;

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';

FLUSH PRIVILEGES;