mysql_secure_installation doesn’t seem to work on the newest Debain

After some googling I think I found what works for me.

Delete anon user
DELETE FROM mysql.user WHERE User=”;

delete non local root user
DELETE FROM mysql.user WHERE User=’root’ AND Host NOT IN (‘localhost’, ‘127.0.0.1’, ‘::1’);

drop test database
DROP DATABASE IF EXISTS test;

drop all other root users
drop user ‘root’@’localhost’;
drop user ‘root’@’127.0.0.1’;
drop user ‘root’@’::1′;

create a new root user with password
CREATE USER ‘root’@’%’ IDENTIFIED BY ‘password’;

make user super user
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;

as always flush stuff
FLUSH PRIVILEGES;