uncomplicate the mysql_secure_installation part about slickstack HOT 2 CLOSED

systemctl enable mariadb
systemctl start mariadb
#mysql_secure_ins-whatever is a garbage script
#run the same commands it does, but without an expect wrapper
#this is a cloud cattle car, not a multiuser system
export PASS=MYVAL
mysql -uroot -e "UPDATE mysql.user SET Password=PASSWORD('$PASS') WHERE User='root';"
mysql -uroot -p$PASS -e "FLUSH PRIVILEGES;"
mysql -uroot -p$PASS -e "DELETE FROM mysql.user WHERE User='';"
mysql -uroot -p$PASS -e "DROP DATABASE IF EXISTS test;"
mysql -uroot -p$PASS -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'"
mysql -uroot -p$PASS -e "FLUSH PRIVILEGES;"
#this disabled everything but remove root login, which in a private VPC you might want on
#but here's the part that does it, ripped out of that script 
#mysql -uroot -p$PASS -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');"
#mysql -uroot -p$PASS -e "FLUSH PRIVILEGES;"