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

FLUSH PRIVILEGES;

Step 4

exit

Step 5

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

A full video tutorial can be found here:

 

This entry was posted in Databases, mysql and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *