echo -e "nn$db_passn$db_passnnnnn" | /usr/bin/mysql_secure_installation

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

stty: standard input: Invalid argument
Enter current password for root (enter for none):
stty: standard input: Invalid argument
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n]  ... skipping.

#!/usr/bin/expect --
spawn /usr/local/mysql/bin/mysql_secure_installation

expect "Enter current password for root (enter for none):"
send "r"

expect "Set root password?"
send "yr"

expect "New password:"
send "passwordr"

expect "Re-enter new password:"
send "passwordr"

expect "Remove anonymous users?"
send "yr"

expect "Disallow root login remotely?"
send "yr"

expect "Remove test database and access to it?"
send "yr"

expect "Reload privilege tables now?"
send "yr"

puts "Ended expect script."

/usr/bin/mysql -uroot -e "DELETE FROM mysql.user WHERE User=''; DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1'); DROP DATABASE IF EXISTS test; FLUSH PRIVILEGES;"