"PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !

To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'

'/usr/bin/mysqladmin' -u root -h hostname password 'new-password'

Alternatively you can run:

'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers."

While mysql_secure_installation works as expected and changes ALL passwords, commands:

'/usr/bin/mysqladmin' -u root password 'new-password'

'/usr/bin/mysqladmin' -u root -h hostname password 'new-password'

DO NOT change ALL root passwords. Mysql user table after running commands:

MariaDB [(none)]> select Host,User,Password from mysql.user;

+----------------+------+-------------------------------------------+

| Host           | User | Password                                  |

+----------------+------+-------------------------------------------+

| localhost      | root | *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4 |

| server6.tst.lt | root | *4A82FDF1D80BA7470BA2E17FEEFD5A53D5D3B762 |

| 127.0.0.1      | root |                                           |

| ::1            | root |                                           |

| localhost      |      |                                           |

| server6.tst.lt |      |                                           |

+----------------+------+-------------------------------------------+