Monthly Archives: December 2018

Set root password MariaDB

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.

After you install MariaDB you log in using the following command:

mysql -u root -p

You may notice that you don’t get prompted for a password. In order to correct this you will need to run the following :

Step 1

SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘yourPassword’);

Step 2

UPDATE mysql.user SET plugin = ‘ ‘ WHERE user = ‘root’ AND host = ‘localhost’

Step 3


Step 4


Step 5

Run mysql -u root -p You will now need your password to log in.

A full video tutorial can be found here: