MariaDB one of the most popular database used on nowadays and created by the MySQL developers. It is free and an Opensource, widely ...
MariaDB one of the most popular database used on nowadays and created by the MySQL
developers.
It is free and an Opensource, widely used by so many users such as Wikipedia, Google, wordpress.com and etc..
It has more numbers of features than MySQL and developed under the General Public License version 2 by the developers
In this tutorial, I will show you how to install the latest version of MariaDB 10.2.12 on Ubuntu 16.04 / LinuxMint 18 / CentOS 7 and Fedora
Installation Steps:
For Ubuntu 16.04 / LinuxMint 18
Step 1: Add the official repository key and MariaDB repo.sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb/repo/10.2/ubuntu xenial main'Step 2: Update the package source list and install MariaDB server
sudo apt-get update
sudo apt-get install mariadb-server
While installation it will ask you to set the password
MariaDB will start automatically once the installation completed, To access MariaDB use the below command as root followed by password
$ mysql -u root -p
Start/Stop/Enable MariaDB process
sudo systemctl enable mariadb
sudo systemctl status mariadb
sudo systemctl start mariadb
sudo systemctl stop mariadb
Install MariaDB on CentOS 7 / Fedora
Step 1: Create or add the official MariaDB repository under /etc/yum.repos.d/MariaDB.repoCentos 7 Entry
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Fedora 26 Entry
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/fedora26-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
For Centos 7
sudo yum install MariaDB-server MariaDB-clientFor Fedora 26/27
sudo dnf install MariaDB-server
Step 3: Access MariaDB
MariaDB will start automatically once the installation completed, if not use the below commands to start it To access the MariaDB use the below command as root followed by password
sudo systemctl enable mariadb.service
sudo systemctl status mariadb.service
sudo systemctl start mariadb.service
sudo systemctl stop mariadb.serviceConnect to MariaDB
$ mysql -u root -p
COMMENTS