Skip to content

Instantly share code, notes, and snippets.

@bryanjhv

bryanjhv/mariadb-secure-installation.sql

Created August 19, 2024 20:30
Show Gist options
  • Save bryanjhv/4df6b1f8cc615fd8c5a63e72b0ce6813 to your computer and use it in GitHub Desktop.
Save bryanjhv/4df6b1f8cc615fd8c5a63e72b0ce6813 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mariadb-secure-installation.sql
DELETE FROM mysql.global_priv WHERE User='';
DELETE FROM mysql.global_priv 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment