MySQL installation in Ubuntu Linux 18.04 LTS

MySQL is an open source and popular RDMS
(Relational Database Management System). It’s widely used in web technology in today’s date, and also it’s part of LAMP (Linux, Apache, MySQL, PHP/Perl/Python) stack.

In this post, we will demonstrate “two methods” to install MySQL database in Ubuntu Linux 18.04 LTS. Following are the two methods. We will walk you through one by one.

Using Ubuntu repository
MySQL Official repository

LAMP (Linux, Apache, MariaDB/MySQL and PHP) with phpMyAdmin on Ubuntu 18.04 LTS

MySQL Installation in CentOS/RHEL 8 Linux.

Prerequisites

1. Installed Ubuntu 18.04 LTS Server
2. root or Sudo access
3. Internet access

Method 1: Using Ubuntu repository.

This method is very straight forward, execute below commands after fulfilling above Pre-requisites.

$ sudo apt update

$ sudo apt install mysql-server

$ sudo mysqladmin -p -u root version

As seen above, MySQL is installed bit older version.

Remove MySQL from the system.

$ sudo apt remove mysql-server

What about when you want to installed the latest version of MySQL? Follow the steps below.

Method 2: MySQL Official Repository

Step 1: Download MySQL Community Edition APT Repository from below link and install the downloaded repository.

https://dev.mysql.com/downloads/repo/apt/

$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.14-1_all.deb

Step 2: Install the downloaded repository with below command. This will open package configuration windows and click on “OK“.

$ sudo dpkg -i mysql-apt-config_0.8.14-1_all.deb

Step 3: Update repositories

$ sudo apt update

Step 4: Install MySQL using same command which we have used in Ubuntu Repository steps. This will again open package configuration windows to set authentication plugin.

$ sudo apt install mysql-server -y

Package Configuration windows to set authentication plugin. Select “OK” with arrow key and press <ENTER> to accept. It will start installation of MySQL database.

Check mysql service should be running

$ sudo systemctl status mysql.service

Step 5:Check MySQL version after installation.

$ sudo mysqladmin -p -u root version

Step 6:Securing MySQL

$ sudo mysql_secure_installation

This will ask some sets of security questions as follows:

1. Would you like to setup VALIDATE PASSWORD component =Y

2. Password valid policy, choose 2 for = Strong

3. Set root password = <pwd>

4. Remove anonymous user = Y

5. Dissallow root login remotely = Y

6. Remove test database and access to it. Y

7. Reload privilege tables now = Y

Step 7: Login in MySQL Shell, enter user password (not mysql root) and verify authentication_string and plugin with command below.

$ sudo mysql

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

Step 8: We will execute ALTER command to configure the root account to authenticate with password. Make sure to choose strong password. Check below authentication methods that root is no longer authenticates using the auth_socket plugin after executing below ALTER command.

mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘Password@1234’;

mysql> FLUSH PRIVILEGES;

Step 9: Now login with root user and password which we have set in Step 8.

That’s it. In this article, we have installed MySQL in Ubuntu 18.04 LTS Linux using two methods. Share your experience through comment box below. Please share it with others and follow us on our Facebook Official Page.