Back to search

mysql_secure_installation

wizard database

MySQL/MariaDB security hardening wizard

Required Packages

sudo apt install -y mysql-server

Steps

Step 1 of 6 17%
Show all steps

Strong password for the database root user. For MariaDB on apt, install mariadb-server instead.

Recommended for production

Generated Output

sudo systemctl start mysql && sudo mysql -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '';" && sudo mysql -u root -p'' -e "DELETE FROM mysql.user WHERE User='';" && sudo mysql -u root -p'' -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');" && sudo mysql -u root -p'' -e "DROP DATABASE IF EXISTS test; DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';" && sudo mysql -u root -p'' -e "FLUSH PRIVILEGES;"

Related

MySQL/MariaDB config systemctl