Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- if [[ ! -f /var/lib/mysql/status.secured ]]; then
- echo "MariaDB -> secure"
- #
- /usr/sbin/service mysql start
- mysqladmin -u root password "$MARIA_ROOT_PASSWORD"
- mysql -u root -p"$MARIA_ROOT_PASSWORD" -e "UPDATE mysql.user SET Password=PASSWORD('$MARIA_ROOT_PASSWORD') WHERE User='root'"
- mysql -u root -p"$MARIA_ROOT_PASSWORD" -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')"
- mysql -u root -p"$MARIA_ROOT_PASSWORD" -e "DELETE FROM mysql.user WHERE User=''"
- mysql -u root -p"$MARIA_ROOT_PASSWORD" -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test_%'"
- mysql -u root -p"$MARIA_ROOT_PASSWORD" -e "FLUSH PRIVILEGES"
- touch /var/lib/mysql/status.secured
- #
- /usr/sbin/service mysql stop
- while [[ "$(/usr/sbin/service mysql status)" != " * MariaDB is stopped." ]]; do
- sleep 1
- done
- echo "MariaDB -> secured"
- fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement