How to install MySQL 8.0 on Ubuntu 24.04

Install MySQL 8.0 via Ubuntu APT repositories

You can install MySQL 8.0 on Ubuntu 24.04 using the system’s built-in APT repositories. This is the easiest method for most people. To start, update your package list with ‘sudo apt update’, then upgrade existing packages using ‘sudo apt upgrade’, and finally install the MySQL server by running ‘sudo apt install mysql-server’.

First, update Ubuntu packages by running the command below.

sudo apt update
sudo apt upgrade

Then, run the command below to install it.

sudo apt install mysql-server

The command above will install MySQL 8.0 ( the current version as I’m writing this) on Ubuntu 24.04.

Install MySQL 8.0 with MySQL Community Server

To install the very latest MySQL 8.0 version on Ubuntu 24.04, you can add the official MySQL Community Server repositories. This lets you install directly from MySQL. First, install some needed tools by running ‘sudo apt install dirmngr ca-certificates software-properties-common apt-transport-https curl lsb-release’.

First, install some prerequisites by running the command below.

sudo apt install dirmngr ca-certificates software-properties-common apt-transport-https curl lsb-release

Then, run the command below to import its repository GPG key.

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

Next, run the command below to add the MySQL 8.0 repository to Ubuntu 24.04.

echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/mysql.gpg] http://repo.mysql.com/apt/ubuntu $(lsb_release -cs) mysql-8.0" | sudo tee -a /etc/apt/sources.list.d/mysql.list

Now that you have successfully added the MySQL 8.0 GPG key and its repositories run the command below to update Ubuntu and install the server.

sudo apt update
sudo apt install mysql-community-server

Once installed, you can use the commands below to start, stop, enable, restart, or disable MySQL service.

sudo systemctl start mysql
sudo systemctl stop mysql
sudo systemctl enable mysql
sudo systemctl restart mysql
sudo systemctl disable mysql

Run MySQL security script

After installing the MySQL database on Ubuntu, it’s recommended to run its security script to enhance and perform some house cleaning.

sudo mysql_secure_installation

Follow the prompts until you’re done.

Uninstall MySQL 8.0

To completely remove MySQL 8.0 from Ubuntu 24.04, you should stop the service, remove the packages, and delete the configuration files. First, stop the MySQL service by running ‘sudo systemctl stop mysql –now’. Then, remove the server packages using ‘sudo apt autoremove mysql-community-server’ and ‘sudo apt autoremove mysql-server’.

sudo systemctl stop mysql --now
sudo apt autoremove mysql-community-server
sudo apt autoremove mysql-server
sudo rm /etc/apt/sources.list.d/mysql.list

That should do it!

Conclusion:

• MySQL 8.0 is a robust and popular open-source relational database management system suitable for various web applications and software.
• 💿 Installing MySQL 8.0 on Ubuntu 24.04 can be accomplished through the default APT repositories or by adding MySQL’s official repositories for the latest stable release.
• After installation, managing MySQL 8.0 involves starting, stopping, enabling, restarting, or disabling the MySQL service using systemctl commands.
• Running MySQL’s security script after installation is recommended to enhance security and perform necessary housekeeping.
• If the need arises to uninstall MySQL 8.0, specific commands can be used to stop, remove, and clean up the installation.