oneliner mysql_secure_install

mysql_secure_install.sh

#!/bin/bash

set -e

if [ $# != 1 ]; then
        echo "Usage: mysql_secure_install.sh \$password"
        exit 1
fi

MYSQL_CMD="/usr/bin/mysql -B"
ROOT_PASSWORD=$1

res=$($MYSQL_CMD -e "SELECT component_urn FROM mysql.component WHERE component_urn = 'file://component_validate_password'")
if [ -z "$res" ] ; then
        $MYSQL_CMD -e "INSTALL COMPONENT 'file://component_validate_password'"
fi


cat <<EOF | $MYSQL_CMD
SET GLOBAL validate_password.policy = 'LOW';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '$ROOT_PASSWORD';
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;
DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
FLUSH PRIVILEGES;
EOF