Ciro Santilli @cirosantilli 35

sudo mysql

sudo mysql -e "CREATE USER $USER"

mysql -e 'SHOW DATABASES'

sudo mysql -e 'CREATE USER user0 IDENTIFIED WITH mysql_native_password BY "a"'
sudo mysql -e 'GRANT ALL PRIVILEGES ON database_name.* TO "user0"'

mysql -u user0 -p

mysql -u user0 -pmypassword

sudo mysql -e 'SELECT * FROM mysql.user'

sudo mysql -e 'SELECT * FROM mysql.db'

sudo mysql -e 'SHOW DATABASES'

sudo mysql -e 'CREATE DATABASE mydb0'

sudo mysql -e 'DROP DATABASE mydb0'

sudo mysql -e 'SHOW TABLES' mydb0

sudo mysql -e 'SHOW TABLES FROM mydb0'

tor-army 100

./cdx-tor.sh infile.txt

cd 2013-dns-census-a-novirt-domains.txt.cdx
./cdx-tor.sh -d out.post domain-list.txt
cd out.post.cdx
cut -d' ' -f1 out | uniq -c | sort -k1 -n | awk 'match($2, /([^,]+),([^)]+)/, a) {printf("%s.%s %d\n", a[2], a[1], $1)}' > out.count

12654montana.com 1
aeronet-news.com 1
atohms.com 1
av3net.com 1
beechstreetas400.com 1