Creating a user in MariaDB

Create new super user with all rights

CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON *.* TO 'user1'@localhost IDENTIFIED BY 'password1';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'user1'@localhost;

Drop the user

DROP USER 'user1'@localhost;