Category: Ubuntu

Added: 26th of May 2018

Viewed: 1727 times

Install MariaDB Database in Ubuntu and other Ubuntu based distributions (Part 1)

Part 1: Install MariaDB in Ubuntu
Part 2: Create a new user

To install MariaDB Database server in Ubuntu and other Ubuntu based distributions enter the following command in your terminal

sudo apt-get install mariadb-server

When MariaDB Database installs it will ask you to set a root password. If you plan to host your own MariaDB Database(s) online it is advisable to set a root password. If your just planning on hosting a local database to practice on, you can skip the root password.



After MariaDB Database has installed you need to login via the Terminal.

To login to MariaDB enter the following command in the terminal
mysql -u root -p


You will be asked to enter your root password, the one you set up whilst installing MariaDB. If you didn't enter a password just click enter.

If you logged in correctly, the MariaDB prompt will be displayed in the terminal.
From here you can create, insert, update, delete, databases, tables, create new users.

Other Tips & Tutorials

Ubuntu

How do I upgrade a single package in Ubuntu and Ubuntu based distributions

Posted: 12th of September 2021

Views: 248

Ubuntu

Create a multiboot USB for your .iso images, using Ventoy on Linux

Posted: 25th of August 2021

Views: 340

Ubuntu

How to find out what date you installed Linux on your machine

Posted: 13th of April 2021

Views: 476

Ubuntu

Install bashtop in Ubuntu and Ubuntu based distributions. Monitor your cpu, memory, disks, network and other processes

Posted: 21st of February 2021

Views: 587

Ubuntu

Ubuntu 20.10 Groovy Gorilla installation error, installer crashed

Posted: 3rd of February 2021

Views: 972

Ubuntu

Find out what version of Ubuntu you are running, using the terminal

Posted: 29th of January 2021

Views: 483

Ubuntu

Install Redshift to automatically adjust the colour of your screen depending on time of day on Ubuntu and Ubuntu based distributions

Posted: 26th of November 2020

Views: 1079

Ubuntu

PulseAudio, Pavucontrol not saving settings after reboot on Ubuntu and Ubuntu based distributions

Posted: 11th of November 2020

Views: 3753

Ubuntu

No sound after installation of Ubuntu or Ubuntu based distribution, install pavucontrol

Posted: 9th of November 2020

Views: 585

Ubuntu

Shutdown Ubuntu and Ubuntu based distributions at a specific time or within (x) minutes

Posted: 30th of October 2020

Views: 671