Install MySQL 8 on Debian 11

This guide will take you through how to install MySQL 8 on Debian 11.

To install MySQL 8 on Debian 11, you need to install MySQL APT repositories;

First off, download MySQL APT repository installer from the downloads page.

You can get the link and use wget command to download.

wget https://repo.mysql.com//mysql-apt-config_0.8.18-1_all.deb

Install the repository installer;

apt install ./mysql-apt-config_0.8.18-1_all.deb

Debian 11 is currently not supported, but repositories for Debian 10 buster can be used. Hence, select debian buster and Ok to proceed.

Next, select Ok and then Ok to proceed.

The script may prompt you to once again select the product. (Ok > Ok).

Once the repository is setup, update the system packages;

apt update

install MySQL 8 on Debian 11 by running the command below;

apt install mysql-server

During installation, you are prompted to set the database root account password. Enter the password and re-enter to confirm.

Use strong password encryption.

MySQL is set to run automatically once installed.

Hence, you can run the command below to remove test databases, disallow root remote login, remove test users…

mysql_secure_installation

You can start/stop/restart MySQL using the commands;

systemctl start mysql

systemctl stop mysql

systemctl restart mysql

You can login to MySQL database

mysql -u root -p

Enter your root password.

You can then proceed to administer your MySQL 8 database on Debian 11.