Skip to content

Instantly share code, notes, and snippets.

@jimrybarski

jimrybarski/mysql_secure.sh

Forked from Mins/mysql_secure.sh
Last active January 1, 2016 22:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jimrybarski/8209182 to your computer and use it in GitHub Desktop.
Save jimrybarski/8209182 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_secure.sh
#!/bin/bash
SECURE_MYSQL=$(expect -c "
set timeout 10
spawn mysql_secure_installation
expect \"Enter current password for root (enter for none):\"
send \"\r\"
expect \"Change the root password?\"
send \"n\r\"
expect \"Remove anonymous users?\"
send \"y\r\"
expect \"Disallow root login remotely?\"
send \"y\r\"
expect \"Remove test database and access to it?\"
send \"y\r\"
expect \"Reload privilege tables now?\"
send \"y\r\"
expect eof
")
echo "$SECURE_MYSQL"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment