Disable IPv6 autoconfiguration in Windows 10:

netsh interface ipv6 set interface "Ethernet" routerdiscovery=disabled
netsh interface ipv6 set teredo disabled
netsh interface ipv6 isatap set state disabled
netsh interface ipv6 6to4 set state disabled

MySQL import/expot:

mysqldump -u user4 -p databasenameX > outputfile.sql
mysql -u user4 -p dbnameX < inputfile.sql


CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

VirtualBox headless debian server:

VBoxManage createvm --name "Debian Squeeze Server" --register
VBoxManage modifyvm "Debian Squeeze Server" --memory 512 --acpi on --boot1 dvd --nic1 bridged --bridgeadapter1 eth0
VBoxManage createhd --filename Debian_Squeeze_Server.vdi --size 10000
VBoxManage storagectl "Debian Squeeze Server" --name "IDE Controller" --add ide
VBoxManage storageattach "Debian Squeeze Server" --storagectl "IDE Controller" --port 0 --device 0 --type hdd --medium Debian_Squeeze_Server.vdi
VBoxManage storageattach "Debian Squeeze Server" --storagectl "IDE Controller" --port 1 --device 0 --type dvddrive --medium /home/debian-6.0.1a-amd64-netinst.iso

Split screen (GNU)

split display horizontally 		C-a S
split display vertically 		C-a | or C-a V (for the vanilla vertical screen patch)
jump to next display region 		C-a tab
remove current region 			C-a X
remove all regions but the current one 	C-a Q

Copy the content/file to all subdirectories in a directory using bash

find ./ -type d -exec cp index.php {} \;

How to replace spaces in file names using a bash script

find -name "* *" -type d | rename 's/ /_/g'    # do the directories first
find -name "* *" -type f | rename 's/ /_/g'


USG Failover SSH status

show load-balance status
show load-balance watchdog


Unifi USG IPv6 DNS

configure
delete system name-server
set system name-server 127.0.0.1 
set interfaces ethernet eth0 dhcp-options name-server no-update
set interfaces ethernet eth0 dhcpv6-pd no-dns
set service dns forwarding name-server 208.67.222.222
commit
save
show dns forwarding nameservers
More: https://community.ubnt.com/t5/EdgeRouter/DNS-Forwarding-Name-Servers/td-p/1117142

Force Linux WIFI from 5GHz to 2.4GHz

Add line to /etc/wpa_supplicant.conf:

scan_freq=2412 2437 2462

This will enable only the channels 1, 6 and 11. Restart wpa_supplicant:

sudo systemctl restart wpa_supplicant.service

And after this, you can check the current channel with command:

iwlist freq


IP info
curl ipinfo.io


Restart Unifi USG`s IPv6
release dhcpv6-pd interface eth0 ; delete dhcpv6-pd duid ; renew dhcpv6-pd interface eth0 ## set interfaces ethernet eth1 ipv6 router-advert prefix ::/64 autonomous-flag false


Bash disable/convert floating point numbers

apt install jq


Example:
fgrep -v -e bond -e lo /proc/net/dev | awk -F' ' '{print $2+$10}'
0
0
2.55189e+11

fgrep -v -e bond -e lo /proc/net/dev | awk -F' ' '{print $2+$10}' | jq '.'
0
0
255193000000


xrand resolution / debian + xfce


cvt 1920 1080
# 1920x1080 59.96 Hz (CVT 2.07M9) hsync: 67.16 kHz; pclk: 173.00 MHz

xrandr --newmode  "1920x1080_60.00"  173.00  1920 2048 2248 2576  1080 1083 1088 1120 -hsync +vsync
xrandr --addmode HDMI-1 1920x1080_60.00
xrandr --output HDMI-1 --mode 1920x1080_60.00



tcpdump -lvi any "udp port 53" 2>/dev/null|grep -E 'A\?'|awk '{print $(NF-1)}'