Can’t start Snap: 'cannot change profile for the next exec call: No such file or directory'

sudo apparmor_parser -r /var/lib/snapd/apparmor/profiles/*

Terminal colours

perl -e 'for(my $j=0; $j<2;$j++) {for(my $i=30; $i < 38; $i++){print "\033[$j;${i}m $j;$i \033[0m\n"}}'

List latest 15 modified files recursively

find . -type f -printf '%T@ %TY-%Tm-%Td %TH:%TM:%.2TS %P\n' | sort -nr | head -n 15 | cut -f2- -d" "

Start deattached screen job that won't terminate itself when done

screen -dmS screen_name bash -c 'echo waiting 5 seconds...; sleep 5; exec bash'

MySQL output to a CSV file (files land in /var/lib/mysql/db_name/ and are owned by mysql)

SELECT order_id,product_name,qty FROM orders WHERE foo = 'bar' INTO OUTFILE 'orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Install CPAN module with 'yes' to all questions

PERL_MM_USE_DEFAULT=1 perl -MCPAN -e 'install This::Is::Module::Name'

How to recover WiFi password in Windows

Run cmd as Administrator

netsh wlan show profile name=MY_SSID key=clear

Change permissions for files and directories separately

find . -type f -print0 | xargs -0 chmod 644
find . -type d -print0 | xargs -0 chmod 755

Disable hibernation in Windows 7

powercfg -h off

Resetting root MySQL password

Stopping MySQL server:
# /etc/init.d/mysql stop
Starting MySQL server without password:
# mysqld_safe --skip-grant-tables &
Connecting to mysql server:
# mysql -u root mysql
Setting up new MySQL root user password
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
Stopping MySQL Server:
# /etc/init.d/mysql stop
Starting MySQL server and test it
# /etc/init.d/mysql start