How to Install MySQL 8.0 on Ubuntu 20.04 LTS

MySQL is a free, open-source database management system based on SQL or Structured Query Language. It is one of the most widely used database systems for several well-known applications. MySQL is used for data warehousing, e-commerce, and logging applications, and its most notable feature is web-based database storage and management. The ease of use and flexibility of MySQL has made it a popular choice for many web applications. One of the key benefits of MySQL is that it runs on multiple platforms, including Windows, Linux, and macOS. This allows developers to create cross-platform applications deployed on various devices. Another benefit of MySQL is that it supports multiple programming languages, making it easy to integrate into existing applications. Lastly, MySQL is highly scalable, which means it can handle large volumes of data without sacrificing performance. This makes it an ideal choice for businesses looking to manage growing amounts of data.

In the latest release of MySQL 8.0, the database management system brings new features and security updates. This new release of MySQL adds support for joins with larger data sets, better performance when importing large files, and various improvements to InnoDB, SQL mode, named ‘strict sql_mode,’ which will make MySQL more compliant with the SQL standard. In addition, there are performance enhancements in this release that include an adaptive query cache, a thread pool for connections, and a faster startup time. Finally, there are multiple security fixes included in this release. Overall, this new release of MySQL provides significant improvements and enhancements that will benefit developers and database administrators alike.

The following tutorial will teach you how to install MySQL Community on Ubuntu 20.04 LTS Focal Fossa using the MySQL official APT repository, which will give you the latest version available on your system using the command line terminal.

Update Ubuntu

First, before proceeding any further, update your system to ensure all existing packages are up to date.

sudo apt update && sudo apt upgrade

Install Required Packages

The tutorial will require the following packages installed. These may be already present as they are widespread packages; if unsure, just run the command.


sudo apt install dirmngr ca-certificates software-properties-common gnupg gnupg2 apt-transport-https curl -y

Note, wget should be installed automatically but run the command to verify if you are unsure.

Import the MySQL 8.0 Community Repository

By default, MySQL 8.0 Community Edition is unavailable on Ubuntu 20.04 LTS Focal Fossa repository; luckily, a repository from the MySQL official repository allows you to import the latest stable version.

First, import the GPG key using the following command.

curl -fsSL http://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | gpg --dearmor | sudo tee /usr/share/keyrings/mysql.gpg > /dev/null

Next, import the repository.

echo 'deb [signed-by=/usr/share/keyrings/mysql.gpg] http://repo.mysql.com/apt/ubuntu focal mysql-8.0' | sudo tee -a /etc/apt/sources.list.d/mysql.list
echo 'deb-src [signed-by=/usr/share/keyrings/mysql.gpg] http://repo.mysql.com/apt/ubuntu focal mysql-8.0' | sudo tee -a /etc/apt/sources.list.d/mysql.list

Users that are using MySQL for development can additionally import the following repositories.

echo 'deb [signed-by=/usr/share/keyrings/mysql.gpg] http://repo.mysql.com/apt/ubuntu focal mysql-tools' | sudo tee -a /etc/apt/sources.list.d/mysql.list
echo 'deb-src [signed-by=/usr/share/keyrings/mysql.gpg] http://repo.mysql.com/apt/ubuntu focal mysql-tools' | sudo tee -a /etc/apt/sources.list.d/mysql.list

Lastly, run an APT update.


sudo apt update

Install MySQL 8.0

Now that you have completed the import of the repository for MySQL, execute the command to install as follows:

sudo apt install mysql-community-server -y

A new pop-up will appear during the installation, prompting you to enter the database root password. Make sure this is secure and recorded. Once entered, press the enter key or the tab key to select the <Ok> and hit the enter button to proceed with the installation.

Example:

How to Install MySQL 8.0 on Ubuntu 22.04 LTS

Note that you will be prompted to re-enter the root password a second time to confirm. REMEMBER THE PASSWORD FOR THE FUTURE!

Next, another pop-up will appear for you to read about the new authentication system.

Select <Ok> to proceed.


Example:

How to Install MySQL 8.0 on Ubuntu 22.04 LTS

Next, set the default selection for the authentication plugin as below.

If unsure, select “Use Strong Password Encryption,” recommended by MySQL.

Example:

How to Install MySQL 8.0 on Ubuntu 22.04 LTS

The installation should finish up after this point. To confirm it has been installed, run the following apt policy command.

apt policy mysql-community-server

Example output:


How to Install MySQL 8.0 on Ubuntu 22.04 LTS

Check the Status of the MySQL 8.0

The installer will automatically start your default MySQL service and configure itself to start automatically on system startup.

Verify that your MySQL service is operational after installation; type the following systemctl status command.

systemctl status mysql

Example output:

How to Install MySQL 8.0 on Ubuntu 22.04 LTS

For new installations, everything should be status ok. Proceed on to securing your MySQL instance.

Below are some of the most common system commands you will require to manage your MySQL systemd service.

Stop the MySQL service:


sudo systemctl stop mysqld

Start the MySQL service:

sudo systemctl start mysqld

Disable the MySQL service at system startup:

sudo systemctl disable mysqld

Activate the MySQL service at system startup:

sudo systemctl enable mysqld

Restart the MySQL service:

sudo systemctl restart mysqld

How to Secure MySQL 8.0

When installing MySQL, the new defaults are considered weak by most standards and raise concerns about the potential of allowing intrusion or exploitation by hackers. One solution is to run the installation security script with the MySQL installation.

First, use the following command to launch the (mysql_secure_installation).


sudo mysql_secure_installation

Next, you will be prompted for your root password that was initially set, and then you will see a question about VALIDATE PASSWORD COMPONENT; this involves defining password complexity checks; for the most part, the default is correct.

Then follow below:

  • Setting the password for root accounts.
  • Setting the password for the accounts.
  • Removal of root accounts accessible from outside the localhost.
  • Removal of anonymous user accounts.
  • Removal of the test database, accessible by default to anonymous users.

Be careful; you use (Y) to delete everything. In addition, if you wish, you can reset your root password by creating a new one; you can ignore it if you want, as you already set it during the initial installation with the pop-ups.

Example:

[joshua@ubuntu-22-04~]$ mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root: 

The existing password for the user account root has expired. Please set a new password.

New password: <---- SET NEW PASSWORD

Re-enter new password: <---- RE-ENTER NEW PASSWORD

Re-enter new password: 
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.

Estimated strength of the password: 100 
Change the password for root ? ((Press y|Y for Yes, any other key for No) : Y <---- Type Y then press the ENTER KEY (SKIP IF YOU ALREADY JUST SET)

New password: 

Re-enter new password: 

Estimated strength of the password: 100 
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y <---- Type Y then press the ENTER KEY.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y <---- Type Y then press the ENTER KEY.
Success.


Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y <---- Type Y then press the ENTER KEY.
Success.

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y <---- Type Y then press the ENTER KEY.
 - Dropping test database...
Success.

 - Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y <---- Type Y then press the ENTER KEY.
Success.

All done! 

How to Update/Upgrade MySQL 8.0

Since you have imported the official APT repository, updating is quick and straightforward; run the following standard APT commands as you would updating any other system package.

sudo apt update && sudo apt upgrade

How to Remove (Uninstall) MySQL 8.0

First, stop the database if you no longer want to use the MySQL database.


sudo systemctl stop mysql --now

Use the following command to remove MySQL and any unused dependencies installed.

sudo apt autoremove mysql-community-server

The above command will blanket cover removing dependencies no longer required.

Comments and Conclusion

If you are looking for a powerful yet free and open-source database management system, MySQL is a great option. It has been used by some of the largest companies in the world and continues to be one of the most popular choices for data storage. Its many features and applications make it easy to see why MySQL is such a well-loved choice for large and small businesses.


Not what you were looking for? Try searching for additional tutorials.

1 thought on “How to Install MySQL 8.0 on Ubuntu 20.04 LTS”

  1. у меня без публичного ключа толком не ставится.
    поэтому перед

    sudo apt install mysql-server
    

    дал команду

    sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0x467B942D3A79BD29
    

    Вроде теперь всё в порядке ))

    Reply

Leave a Comment