
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