Group

If you're working with Ubuntu 22.04 and need a robust, open-source relational database system, MySQL is a go-to solution trusted by developers and organizations around the world. Whether you're managing a small web application or an enterprise-level system, MySQL provides the flexibility and power you need to store and manage your data effectively.

In this Forum, we’ll explore how to Install MySQL on Ubuntu 22.04 using a simple and structured approach. We’ll also reference the trusted step-by-step tutorial from Vultr to ensure accuracy and reliability. This post is perfect for beginners setting up MySQL for the first time, as well as experienced users looking for a quick reference.

Why Install MySQL on Ubuntu 22.04?

Ubuntu 22.04, also known as Jammy Jellyfish, is a Long-Term Support (LTS) version, making it an ideal environment for production servers and applications. MySQL is a proven database engine widely used for applications in e-commerce, content management, analytics, and more.

Installing MySQL on Ubuntu 22.04 allows you to:

• Build reliable data-driven applications

• Set up secure user access and data control

• Integrate with programming languages like PHP, Python, and Java

• Run web platforms like WordPress, Joomla, and Drupal

Prerequisites

Before beginning the installation, make sure you have the following:

• A system running Ubuntu 22.04 (desktop or server version)

• A non-root user with sudo privileges

• Access to a terminal or SSH connection

• Stable internet connection for package downloads

Step-by-Step: Install MySQL on Ubuntu 22.04

Step 1: Update the Package Index

Start by updating the package list to ensure you get the latest versions of packages and dependencies:

sudo apt update

Step 2: Install MySQL Server

Now, install the MySQL server package:

sudo apt install mysql-server

This command installs the MySQL server and related tools on your system. When prompted, type Y and press Enter to continue.

Step 3: Start and Verify MySQL Service

Once the installation is complete, check if the MySQL service is running:

sudo systemctl status mysql

You should see the status as “active (running).” If not, you can manually start it using:

sudo systemctl start mysql

Step 4: Secure the Installation

MySQL provides a security script to configure and remove potentially dangerous defaults:

sudo mysql_secure_installation

This script will prompt you to:

• Set a root password

• Remove anonymous users

• Disallow remote root login

• Remove the test database

• Reload the privilege tables

Answer each question based on your security preferences (it’s usually safe to accept the defaults for a basic setup).

Step 5: Log Into MySQL

To access the MySQL shell as the root user, type:

sudo mysql

You’ll now see the mysql> prompt where you can execute SQL commands.

Step 6: Create a New Database and User

Let’s create a database and user for your application:

CREATE DATABASE mydatabase;

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';

FLUSH PRIVILEGES;

EXIT;

This setup creates a secure environment for your application to interact with the MySQL database.

Optional: Enable Remote Access

If you plan to connect to your MySQL server remotely:

1. Edit the config file:

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

1. Find and change:

bind-address = 127.0.0.1

to

bind-address = 0.0.0.0

1. Restart MySQL:

sudo systemctl restart mysql

1. Adjust your firewall to allow port 3306.

Step 7: Uninstall MySQL (Optional)

If you ever need to remove MySQL completely:

sudo apt remove --purge mysql-server mysql-client mysql-common

sudo apt autoremove

sudo apt autoclean

Conclusion

Installing MySQL on Ubuntu 22.04 is a straightforward process when following the right steps. With your database server up and running, you can now begin building powerful applications or managing complex data sets with ease.

For detailed instructions and ongoing updates, visit the official Vultr guide. If you encounter issues or want to share your experience, feel free to join the forum discussion and help others learn from your journey!