These steps worked for me on several Systems using MariaDB.

log into MYSQL as root

mysql -u root

Create new user (admin) and Grant privileges. To a new user execute:

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';
FLUSH PRIVILEGES;

exit

service mysql restart