How to Install MySQL 5.7 on Ubuntu 22.04 LTS

In this Article we are going to learn How to install MySQL 5.7 on Ubuntu 22.04 LTS using command line, creating new user and enabled remote access in MySQL 5.7.

Step #1: Add MySQL APT Repository

Download the MySQL repository by executing the following command

Update the system Packages:

sudo apt update

We need to Install wget using below command:

sudo apt install wget -y

Download the repository using the below command:

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

Once downloaded install repository using below command:

sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb

In the prompt, choose Ubuntu Bionic and click Ok

The next prompt shows MySQL 8.0 chosen by default. Choose the first option and click OK

In the next prompt, select MySQL 5.7 server and click OK.

The next prompt selects MySQL5.7 by default. Choose the last option Ok and click OK

Step #2: Update MySQL Repository:

Update your system package:

sudo apt-get update

Let’s search for MySQL 5,7 using below command:

sudo apt-cache policy mysql-server

Step #3: Install MySQL 5.7 on Ubuntu 22.04 LTS

Before Installing MySQL 5.7 you need to run this command:

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
sudo apt update

we are going to install MySQL 5.7 client, MySQL 5.7 server with the below command:

sudo apt install -f mysql-client=5.7* mysql-community-server=5.7* mysql-server=5.7*

Hit the y key to start installation of MySQL 5.7 on Ubuntu 22.04 LTS

Enter and re-enter root password:

Step #4: Secure MySQL 5.7 Installation on Ubuntu 22.04LTS:

Run the following commands

sudo mysql_secure_installation

Provide the root password set above and you will have output like this:

ubuntu@ip-172-31-44-141:~$ sudo mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?

Press y|Y for Yes, any other key for No: y

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1
Using existing password for root.

Estimated strength of the password: 25
Change the password for root ? ((Press y|Y for Yes, any other key for No) : no

 ... skipping.
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
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
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
 - 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
Success.

All done!

Step #5: Check MySQL 5.7 version

To confirm the installed version,Login to MySQL 5.7 Server using the below command.

mysql -u root -p 

Check the version using below command:

Here we have covered Install MySQL 5.7 on Ubuntu 22.04 LTS.

Step #6: Create MySQL User

Let’s create user using below command

CREATE USER 'devopshint'@'%' IDENTIFIED BY 'Devops@123';

Step #7: Enable MySQL remote access

By default, In MySQL database server remote access is disabled for security reason.

To enable remote connections of MySQL Server, we have to change bind-address in MySQL configuration file.

Open the /etc/mysql/mysql.conf.d/mysqld.cnf file

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Save the file and restart mysql

sudo systemctl restart mysql

To Restart, Stop and check the Status run the below commands:

sudo systemctl restart mysql
sudo systemctl stop mysql
sudo systemctl status mysql

Conclusion:

In this article, We have performed ,How to Install MySQL 5.7 on Ubuntu 22.04 LTS System, creating new user and enabled remote access in MySQL 5.7.

Related Articles:

• How to Install MySQL 8.0 on Ubuntu 18.04/16.04
• How to Install MySQL 8 on CentOS 8
• How to Install MariaDB on Ubuntu 18.04/16.04 LTS

Reference:

MySQL Official Documentation