NVIDIA GTX Graphics Cards | eBay
Buy best selling Linux books

<< View All Computer Tips

Added On: 16/06/19   |    Category: MariaDB    |    Number of Views: 553


Other Tutorials:

Install MariaDB database in Ubuntu based distributions 2019   



MariaDB powers millions of databases. It can be found running at the back-end of blogs, shopping carts and many other online applications.

If you are interested in learning about basic database administration on Linux, it is handy to learn how to do this through the terminal. It will give you a better understanding of database administration tools such as PHPMyAdmin. PHPMYAdmin provides a GUI for the most common database tasks such as INSERT, UPDATE, and DELETE so you don't need to use the terminal.

This tutorial will show you how to install MariaDB in Ubuntu, Ubuntu based distributions.

Installing MariaDB. Open your terminal and enter the following command to install MariaDB package in your Linux distribution

sudo apt-get install mariadb-server


After installation, enter the following command.
sudo mysql_secure_installation


You will be asked the following questions to secure your MariaDB installation.

Enter current password for root (enter for none):
Since this is the first installation, just press enter

Change the root password? [Y/n] Y
It is always important to set a root password, so enter Y and press enter. You will then be prompted to enter a new password and the re-type the password

Remove anonymous users? [Y/n] Y
Enter Y and press enter

Disallow root login remotely? [Y/n] Y
Enter Y and press enter

Remove test database and access to it? [Y/n] Y
Enter Y and press enter

Reload privilege tables now? [Y/n] Y
Enter Y and press enter


After installation you will be greeted with the following message.

All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!


Now we need to login to MariaDB database. In the terminal enter the following command
mysql -u root -p


You will be prompted for the password you enter earlier. If successful you will then be at the MariaDB prompt
MariaDB [(none)]>



I cannot login to MariaDB


If you enter your password and get the following message below, please enter sudo mysql_secure_installation in the terminal and go through the security questions again
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


If you are sure your password is correct, you probably need to update to root privaleges on MariaDB, so please try the following.

Enter the following in your terminal. Enter your root password which will make you a root user.
sudo su


Login to MariaDB database, using the password your created earlier.
mysql -u root -p


After this enter the following command replacing 'password' with your real password and press enter.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';


After this try to login again.