Category: Ubuntu

Added: 26th of May 2018

Viewed: 1273 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

Download Microsoft Edge preview version for Ubuntu and Ubuntu based distributions

Posted: 22nd of October 2020

Views: 43

Ubuntu

Create a really simple banner using GIMP (GNU Image Manipulation Program) in Linux

Posted: 7th of August 2020

Views: 166

Ubuntu

Install the tree package to list folders and files in a tree like format inside the terminal on Linux

Posted: 22nd of July 2020

Views: 167

Ubuntu

Ubuntu 4.10, Warty Warthog. The first Ubuntu Linux Distribution

Posted: 6th of October 2019

Views: 962

Ubuntu

Sim City 4 Deluxe Edition Install Wine Linux. Trouble installing from CD/Disk 2

Posted: 19th of May 2019

Views: 1228

Ubuntu

Where are the fonts located in Ubuntu and other Ubuntu based distributions

Posted: 3rd of June 2018

Views: 1335

Ubuntu

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

Posted: 26th of May 2018

Views: 1273

Ubuntu

Convert .mkv video to .png images using ffmpeg

Posted: 24th of May 2018

Views: 2622

Ubuntu

Shutdown Ubuntu using the terminal

Posted: 20th of May 2018

Views: 1142

Ubuntu

Running Sketchup 8 in Wine. Sketchup was unable to initialize OpenGL, Linux

Posted: 29th of May 2016

Views: 3575