Installing MariaDB on LINUX/UNIX

0
111
MariaDB Installation

MariaDB is a drop-in replacement in MySQL. It is simple to set up and provide many speed and execution changes, It is also simple to coordinate into most MySQL arrangements. Similarity inquiries can be found at: MariaDB vs MySQL – Compatibility. MariaDB offers more memory than MySQL, including Cassandra (NoSQL), XtraDB, and OQGRAPH.

Instructions for installing MariaDB:

These instruction list is useful for installing MariaDB 5.5 in Ubuntu without MySQL.

Step 1: The software-properties-common package should as of now be installed, however in the event of some unforeseen issue use this command in terminal:

sudo apt-get install software-properties-common

Import the MariaDB open key utilized by the package management system:

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db

After this you can add the MariaDB repository:

sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu trusty main'

Now reload the package database:

sudo apt-get update

Step 2: MariaDB Installation

After all things set up you need to use this command for installing MariaDB:

sudo apt-get install mariadb-server

You may receive some prompt in which you need to Enter Y and continue. Then you will be ask for setting up a password. Use a strong password and continue. You need to stop MariaDB before continuing the process.

sudo service mysql stop

Step 3: Configure MariaDB
Create MariaDB directory structure with following commands:

sudo mysql_install_db

Start program:

sudo service mysql start

Now secure MariaDB by removing testing databases.

sudo mysql_secure_installation

After that Enter your password and continue with entering “Y” in all prompts.

Step 4: Verify Installation

Check MariaDB installation with following command.

Mysql -v

If you want to close MariaDB then use:

Exit

Stop MariaDB with:

sudo service mysql stop

Restart MariaDB with:

sudo service mysql restart

Check the status:

sudo service mysql status