Skip to content

Instantly share code, notes, and snippets.

@chenkai0567

chenkai0567/mysql_secure.sh

Forked from Mins/mysql_secure.sh
Created November 20, 2016 19:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save chenkai0567/81e66b3b26dccd7c0ca958a3d186b72f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save chenkai0567/81e66b3b26dccd7c0ca958a3d186b72f to your computer and use it in GitHub Desktop.
Download ZIP
Automating mysql_secure_installation
Raw
mysql_secure.sh
#!/bin/bash
aptitude -y install expect
// Not required in actual script
MYSQL_ROOT_PASSWORD=abcd1234
SECURE_MYSQL=$(expect -c "
set timeout 10
spawn mysql_secure_installation
expect \"Enter current password for root (enter for none):\"
send \"$MYSQL\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"
aptitude -y purge expect
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment