Hi Techies! Let’s learn about “How to install MySQL 8 in Ubuntu 18.04 Linux”, we will look at the MySQL community edition server, installation step by step in Ubuntu 18.04.
MySQL is the Relation Database, which is used to store the data. It Is open-source and widely used in the industries.
MySQL written in C and C++. It has also been tested to be a “fast, stable and true multi-user, multi-threaded SQL database server”.
First, we will download the MySQL 8 Community Edition installer for Ubuntu 18.04 LTS.
Now right-click on “Download” and then select “Copy link address” and move to a terminal to download the bundle of MySQL 8.
So, now we will install wget in Ubuntu 18.04 to download the MySQL Packages.
In Ubuntu 18.04:
$ sudo apt install wget
The QUICK view to installing MySQL in Linux read the POST to get detailed knowledge about the installation.
Quick view to Install MySQL 8 in Ubuntu 18.04 LTS Linux.
Install MySQL 8 on Ubuntu 18.04 Step by Step
STEP 1: Download the MySQL Community Edition 8 Package in Ubuntu 18.04 to Install
$ wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_8.0.25-1ubuntu18.04_amd64.deb-bundle.tar
So here we have downloaded the bundle tar file for MySQL 8. you can check in the same directory by using the ls command.
STEP 2: Extract the Package of MySQL 8 on Ubuntu 18.04 LTS Linux
$ tar -xvf mysql-server_8.0.25-1ubuntu18.04_amd64.deb-bundle.tar
So with the help of the tar command, we have extracted the packages for MySQL 8, now we have to install all the deb packages for MySQL 8
STEP 3: Install the Package of MySQL 8 using the dpkg command in Ubuntu 18.04.
$ sudo dpkg -i *.deb
Once we start installing all the MySQL 8 deb package on Ubuntu 18.04, we will get some of the dependencies errors on the terminal.
$ sudo apt-get install -f
So, let’s install the dependencies by using the above command
It will ask for a password for the MySQL Community Server 8, which we are installing on Ubuntu 18.04.
So, again re-enter the Password for MySQL 8
So now let’s choose the Authentication Plugin, which has two methods the legacy authentication, also known as the OLD method, or keep the Strong Password Encryption.
So select authentication methods and click on “OK” to Install MySQL 8 on Ubuntu 18.04.
STEP 4: Check the Version of MySQL in Ubuntu.
Let’s check the installed version of MySQL by –version option or log into the database to check the version.
$ mysql --version
$ mysql -h localhost -uUsername -pPassword
Create a Database on MySQL 8.
So, now let’s create the database on newly Installed MySQL 8 on Ubuntu 18.04
mysql> create database name_of_the_Database; Example: mysql> create database tastethelinux;
So, we have created a database named “tastethelinux” on MySQL 8 Ubuntu.
We have used the “show databases” command to check the MySQL database that we have created.
Install MySQL 8 in Rocky Linux. Thanks for reading the POST. Keep sharing and supporting us!