MariaDB with unix_socket and whithout

mariadb.md

Default install:

MariaDB [(none)]> SELECT host, user, password, plugin FROM mysql.user LIMIT 0,1;
+-----------+------+----------+-------------+
| host      | user | password | plugin      |
+-----------+------+----------+-------------+
| localhost | root |          | unix_socket |
+-----------+------+----------+-------------+
1 row in set (0.00 sec)

To remove:

UPDATE mysql.user SET plugin = '' WHERE user = 'root' AND host = 'localhost';

To add password:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mySecretPassword');
FLUSH PRIVILEGES;