The post will explain, how to install MariaDB Server 10.0 on Ubuntu 14.04 LTS (Trusty Tahr) . MariaDB which is now a days very popular. It is fork of MySQL and best alternate of MySQL. Red Hat has already announced the MariaDB as default Database in Verion RHEL 7.0.
I surely suggest you to know about the history of MariaDB. The best reference which I always find is Wikipedia pages.
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Being a fork of a leading open source software system, it is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle. Contributors are required to share their copyright with the MariaDB Foundation (Reference from Wikipedia)
Install MariaDB Server On Ubuntu 14.04 LTS
Installing MariaDB server is quite easy. We are doing this practical on freshly installed Ubuntu 14.04 LTS Operating System.
Follow the given below steps to install MariaDB server version 10.0 .
Step 1 : Add apt repository
Add the MariaDB repository information in apt. For this run the below given command.
sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db sudo add-apt-repository 'deb http://download.nus.edu.sg/mirror/mariadb/repo/10.0/ubuntu trusty main'
Step 2: Update apt and install MariaDB Server
Run the below given command for installing MariaDB server.
sudo apt-get update sudo apt-get install mariadb-server
While installation on screen you can see, it is asking for setting MariaDB root password.
Give strong password for MariaDB Server.
After installation you can directly login into MariaDB server. Because bydefault the service will be running. It is important to note that here the service name is MySQL .
To login into MariaDB server as root, use the below given command.
mysql -u root -p
See the below given screenshot from my system as reference.
In below screenshot you can see the MariaDB [(none)]> console, through which you can also easily identify it is MariaDB Server.
How to start/stop/status/restart MariaDB service
To start the MariaDB Server, run the command
sudo service mysql start
To stop the MariaDB Server, run the command
sudo service mysql stop
To restart the MariaDB Server, run the command
sudo service mysql restart
To get running status, run the below given command
sudo service mysql status
Check which port MariaDB server is listening
In this section we will use two command ss and netstat to find the listening port by MariaDB server.
As we know, service name is mysql. We will use the ss command here, it is nice alternate of netstat command.
ByDefault MariaDB server use the port no. 3306
sudo ss -ltnp|grep mysql
See the below reference from my system
sharad@ubuntu:~$ sudo ss -ltnp|grep mysql
LISTEN 0 100 127.0.0.1:3306 *:* users:(("mysqld",3667,21))
sharad@ubuntu:~$
In case, you want to use netstat command to check listening port, run the below command
netstat -tanp|grep 3306