mysql_secure_install.sql

-- for 5.6
-- UPDATE mysql.user SET Password=PASSWORD('your_password') WHERE User='root';

-- for generic
-- ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password';

-- for 5.7
-- UPDATE user SET authentication_string=PASSWORD('your_password') WHERE User='root';

-- for 8.0
INSTALL COMPONENT 'file://component_validate_password'
SET GLOBAL validate_password.policy = 'LOW'
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_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;