Creating a MySql 8.x Database and user account

Be it for WordPress, or otherwise, creating the database and it’s user account is simple. Just log into MySql as root user, then :

CREATE DATABASE mydatabase;

CREATE USER 'db_user_name'@'localhost' IDENTIFIED BY 'strong_password';

GRANT ALL PRIVILEGES ON mydatabase.* TO 'db_user_name'@'localhost';

DROP USER 'db_user_name'@'localhost';

DROP DATABASE mydatabase'