I am running a brand new Ubuntu 16.04 virtual machine to perform some testes with MariaDB AND Nginx AND PHP7.
When I was installing MariaDB (trough apt-get install mariadb-server) I was not asked to set a password for root user, like it is when we do install MySql-server.
Then I installed MySql Workbench as a client to MariaDB server.
So, I sit a password to the root user with this syntax:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123'); and now the root has a encrypted password.
If I set the same password for the user ig2, using the same syntax used to sit root's password, I can have a successful connection.
The root user can connect with or without password.
In resume, I don't know what is happening, and I don't know how to make the root to get access to the server, trough a client application like Workbench.
Does someone can explain me?