MariaDB

INIT SECURE DB

$ mysql_secure_installation

CREATE NEW USER|GRANT ALL PRIVILEGES

mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password'; 
mysql> CREATE USER 'newuser'@'[IP|DOMAIN]' IDENTIFIED BY 'password'; 
mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; 

mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost'; 
mysql> FLUSH PRIVILEGES;