QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Install MySQL in Ubuntu using Terminal

By Neha T Leave a Comment

MySQL has gathered a tremendous audience due its ease of use to handle the databases. It is often referred to as Relational Database Management System (RDBMS). The reason behind its popularity is that it is compatible with almost every platform like BSDi, FreeBSD, Microsoft Windows, Oracle Solaris, Linux, etc.

MySQL operates as a client-server software, there can be numerous clients which can query to a server system, changes can also be made by a client system to the data on the front-end but not on the back-end. MySQL stores data using the database engines, but the user will not interact with it. They only deal with the database.

Why MySQL in Ubuntu?

If we talk about the use of MySQL in Ubuntu, we must know that the server administration can be best handled by the Linux operating system, therefore, many people prefer to handle their Databases via MySQL. Now you may be thinking of why not SQL Server 8 because it’s not directly handled through the Linux system. For that we have to install Wine, that may not be your choice. There are various features of MySQL due to which you may opt for this database handler, some of them are:

  • Scalability
  • Easy to Use
  • Reliability
  • Inexpensive

In order to have a Graphical tool for designing the database and administrating it, you must use MySQL Workbench. However, you can go for phpmyadmin also, but the major difference between the two is that, ‘MySQL Workbench’ provides the comfort to administrate multiple Databases and better customizing options as compared to the ‘phpmyadmin’. Your perception matters a lot.

Steps to Install MySQL in Ubuntu using Terminal

Step 1: Firstly, you should install the update using the “Advance Packaging Tool” which is a package management tool, if you have recently installed Ubuntu, then type “sudo apt-get update” and press enter, so that all the packages get updated.

how-to-install-mysql-in-ubuntu-step1

Step 2: In order to install “MySQL Server”, just type “sudo apt-get install mysql-server”, and press enter. Through “apt” it is easy to install MySQL Server.

how-to-install-mysql-in-ubuntu-step2

Step 3: Once you press enter, some sort of processing will be done, you may get information about the amount of extra memory needed. Type “y” to continue.

how-to-install-mysql-in-ubuntu-step3

Step 4: Soon the installation will get started, it may take a while to properly install the mysql server. Then, it will ask you to set a password so as to personalize the server. It is optional, you can set it later on using the command “mysql_secure_installation”.

Here, I have set the password and selected “OK” using the arrow keys.

how-to-install-mysql-in-ubuntu-step4

Step 5: In the next step you are required to repeat the password and click “OK.”

how-to-install-mysql-in-ubuntu-step5

Step 6: Now, it’s properly configured. You can safely interact with the client program using the command “mysql -u root -p”. Press enter.

how-to-install-mysql-in-ubuntu-step6

Step 7: Provide the password which you have already set for MySQL.

how-to-install-mysql-in-ubuntu-step7

Step 8: In case you are required to change or have forgotten the password, use the command “dpkg-reconfigure mysql-server”.

how-to-install-mysql-in-ubuntu-step8

Step 9: “MySQL >” will be visible to you, now you can create the database and manage it accordingly.

To go back to Ubuntu, press “Ctrl + d”.

how-to-install-mysql-in-ubuntu-step9

Step 10: To stop the server, write “sudo mysql service stop” and press enter. Similarly, you can use, start or restart in place of stop to again start it.

It’s done, enjoy the experience of handling the databases with this free software.

how-to-install-mysql-in-ubuntu-step10

You Might Also Like:

how-to-install-mysql-workbench-in-ubuntuHow to Install MySQL Workbench on Ubuntu How to install lamp (Linux, Apache, MySQL and Php) in Ubuntu 14.04 How to install and configure uTorrent server in Ubuntu 14.04 how-to-install-and-configure-apache-web-servers-in-ubuntuHow to Install and Configure Apache Web Server in Ubuntu How to install PHP and Apache Server in Ubuntu 14.04 how-to-use-and-install-telnet-in-ubuntuHow to Install and Use TELNET in Ubuntu How to Display your Password while using Terminal in Ubuntu 14.04 how-to-install-and-configure-ssh-in-ubuntuHow to Install and Configure SSH (Secure SHell) in Ubuntu

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to track Snapdeal order
  • How to Split PDF file
  • How to create a new label in gmail
  • How to Change Your Username in Gmail?
  • How to avail latest snapdeal offers

Copyright © 2023 · QueHow · Contact Us