MySQL Installation On Ubuntu 1

Mysql installation on Ubuntu:

In this post we will discuss about MySQL Installation and configuration on Ubuntu machine using apt package repository.

Issue below commands in the same order as given below to install MySQL on Ubuntu.

Below is the snapshot of above install command.

MySQL Installation

Start MySQL:

For First run, we need to start mysql server with root access and need to create some databases or tables and should grant permissions to other users on those newly created instances.

Issue below command from terminal and provide root user password on Ubuntu machine. It is not MySQL password, it is our root user password on Ubuntu.

mysql root

Creating new Database and Granting Access to Other Users:

Issue below commands in mysql command prompt after logging through root user.

mysql create db

Database Population:

As in the above section, we have granted all privileges to all other users, now we can directly login to MySQL without root access and perform DDL or DML operations.

In the below, we are creating emp table under TestDB database and inserting values into emp table and retrieving the results back from emp table. Below are the commands to perform these actions.

mysql ddl

Creation of Dedicated User for MySQL:

In this blog, we use MySQL for hive local metastore setup and also for testing SQOOP import and export functionality from other relational databases. So, it is better to have dedicated user id (mysql_usr) for MySQL access under mysql_grp in ubuntu.

We can follow below command in the same sequence to add a new user mysql_usr to new group mysql_grp.

mysql user

About Siva

Senior Hadoop developer with 4 years of experience in designing and architecture solutions for the Big Data domain and has been involved with several complex engagements. Technical strengths include Hadoop, YARN, Mapreduce, Hive, Sqoop, Flume, Pig, HBase, Phoenix, Oozie, Falcon, Kafka, Storm, Spark, MySQL and Java.

Leave a comment

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

Review Comments
default image

I have attended Siva’s Spark and Scala training. He is good in presentation skills and explaining technical concepts easily to everyone in the group. He is having excellent real time experience and provided enough use cases to understand each concepts. Duration of the course and time management is awesome. Happy that I found a right person on time to learn Spark. Thanks Siva!!!

Dharmeswaran ETL / Hadoop Developer Spark Nov 2016 September 21, 2017