• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
sharadchhetri.com

sharadchhetri.com

Linux,Cloud Computing And DevOps

  • Home
  • Linux
  • CloudComputing
    • Introduction Cloud Computing
    • Amazon AWS
  • Free E-Books
  • About Me

Install MariaDB Server 10.0 on Ubuntu 14.04 LTS ( Trusty Tahr )

November 15, 2014 by Sharad Chhetri Leave a Comment

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.

MariaDB Server 10.0.14

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.

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

Do'nt be greedy, share the knowledge!

  • Click to share on Facebook (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Related

Filed Under: Database Server, Linux Tagged With: MariaDB Server

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Follow Us

  • Facebook
  • Twitter
  • GitHub
  • YouTube

Recent Posts

  • How to install Java (OpenJDK) on Ubuntu Linux
  • How to install Groovy on Ubuntu 20.04 LTS
  • How to Disable selinux in Red Hat or CentOS
  • How to remove date from WordPress Post URL
  • How to install Mariadb 10.4 server on CentOS 8 / RHEL 8

Top Posts & Pages

  • How to delete mail queue in Postfix
  • How to fix read only USB pen drive in Ubuntu
  • How to set hostname and FQDN on CentOS 7 and RHEL 7
  • How to start / stop / restart / reload iptables on CentOS 7 / RHEL 7
  • 4 different commands to check the load average in linux
  • How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
  • How to setup Jenkins Credentials for Git repo access
  • How to print particular line number by using sed command
  • How to create Jenkins user by command line and GUI
  • How to find absolute path of command on Linux / Unix : which command

DevOps Posts

  • vagrant cloud flow

    Install Vagrant on Ubuntu and create first VM

  • git jenkins credential github

    How to setup Jenkins Credentials for Git repo access

  • terraform

    how to install terraform in Linux : CentOS-Ubuntu

  • docker image

    How to create Ubuntu docker base image

  • Install Ansible on Ubuntu / CentOS / RHEL

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Sharad Chhetri is an experienced Linux - Cloud Engineer & freelancer. Working on Open Source Technology since RHEL 4.0 (Red Hat Enterprise Linux). He loves sharing the knowledge which earned from real scenarios. Don't be surprised if you find him in technology seminars and meetup groups. You can contact him on email for freelance projects at admin@sharadchhetri.com. Read More…

Tags

Amazon AWS apache automation awk bash script CentOS centos 7 debian devops docker freebsd ftp ghost git grep hostname jenkins kvm linux linux command linux commands MariaDB Server mysql Nagios nginx Octopress owncloud Owncloud 6 php postfix postgres python Red Hat rpm sed selinux ssh swap ubuntu user management vagrant varnish virtualbox vsftp wordpress

Recent Comments

  • Ali on How to delete mail queue in Postfix
  • Mehar on How to install Java (OpenJDK) on Ubuntu Linux
  • Ramone Burrell on How to fix read only USB pen drive in Ubuntu
  • Pera on How to fix read only USB pen drive in Ubuntu
  • Ubuntu on How to fix read only USB pen drive in Ubuntu
  • Nitin Sharma on Install and configure rsyslog Centralized logging server in CentOS 6.5
  • Sharad Chhetri on Install and configure rsyslog Centralized logging server in CentOS 6.5
  • nitin on Install and configure rsyslog Centralized logging server in CentOS 6.5

Copyright © 2009 - 2021 · All Rights Reserved sharadchhetri.com · · Privacy Policy ·
· sitemap.xml · ·The content is copyrighted to sharadchhetri.com and may not be reproduced on other websites without our permission. ·

Copyright © 2021 · Genesis Sample on Genesis Framework · WordPress · Log in