• Rutvik Hajare

How to Install MySQL in Ubuntu Linux

Outcome: This tutorial teaches you to Install MySQL inn Ubuntu based Linux Distro. You'll also learn how to verify your installation and how to connect to MySQL.



MySQL is the ultimate database management system. It is used in almost every stacks. MySQL is an open source database management system.


MySQL uses tabular data , also known as relational database. It means all the data is stored in the tabular form to access data easily and organise. For managing the data SQL ( structured query language ) is used.


Installing MySQL :


There are two methods


1) Install from Ubuntu repositories


first make sure your all repositories are updated, run below command


sudo apt update   or use
sudo apt-get update

Now install MySQL


sudo apt install mysql-server -y

2) Installing MySQL using the official repository


Go to this link and download the DEB package



Now it's time the sending the request. Open the terminal and type following command to download the package:


curl -OL https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_al.deb

Now to start installation use dpkg command


sudo dpkg -i mysql -apt-config*

Now you will see the package configuration in your terminal

Now go to ok and press ENTER


Now enter password for it and again press ok.



Now you have successfully installed MySQL


VERIFY YOUR MYSQL INSTALLATION :


run below command :


sudo systemctl status mysql.service

You'll see the Active status in the terminal


To start the service use following command :


sudo systemctl start mysql.service

How to run the Queries in MySQL


To run the queries you need to the first connect to the server using MySQL.

so to do that run the following command


mysql -h host_name -u user -p

you can directly enter your password , to skip the entering password step.

by using following command:


mysql -u test_user -p9876

where 9876 is password.


Now you are in the MySQL database management system.


To disconnect from the server and leave the prompt,type:


QUIT
or 
/q

If you need any kind of help about the MySQL type


mysql --help

35 views0 comments

Recent Posts

See All

Create Your Own Disposable Email Address with Gmail

A temporary mail addresses are very useful when you don't want to share your real email address with a website. The source code generated by Labnol. How temporary mail addresses work- By just mask you

Overview

Doceeo gives the ideas, tricks, tips and tutorials about the technology.
get info about the OS.
@2020 all right are reserved by Doceeo

Contact

  • Facebook
  • Twitter
  • Pinterest

Follow on Reddit

reddit-alien-red-st.jpg