How to install MySQL 8.0 on Debian 10 and 11

This article will show how to install MySQL 8.0 on Debian 10. X and 11.X step by step.

MySQL community server is a free open-source, popular, cross-platform database management system.

Step1: Add MySQL apt repository.

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

Step2: Install the MySQL repository package using the following dpkg command.

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

MySQL server version mysql-8.0 will be auto-selected, then scroll down to the last option Ok and click [Enter] to finish the configuration and installation of the release package, as shown in the screenshot.

Step3: Update the latest package information and Install MySQL 8.

Next, download the latest package information from all configured repositories, including the recently added MySQL repository.

sudo apt-get update

sudo apt-get install mysql-server

Type Y to continue.

Now enter the password for root user.

Re-enter the password for root user.

Press enter.

Afterward, you will be asked to select the default authentication plugin to use, then use the right arrow to choose Ok and press [Enter] to complete the package configuration.

Step 4: Let’s check the Installed MySQL Server version.

mysql -V

Step5: let’s verify the MySQL Server status by using the below command.

systemctl status mysql

MySQL Post Installation steps:

Step 1: Secure MySQL Server Installation

By default, the MySQL installation is unsecure. To secure it, run the security script which comes with the binary package. You will be asked to enter the root password you set during installation.

Step2: Enter a new password for root user and Answer the security questions Yes/Y/No/N.

Step 3. Connect to MySQL Server using the below command.

mysql -u root -p

Then, provide a password for root.

To get a list of databases present in MySQL Server run the command show databases;

mysql> show databases;

+——————–+

| Database           |

+——————–+

| information_schema |

| mysql              |

| performance_schema |

| sys                |

+——————–+

#How to install MySQL 8.0 on Debian 10 and 11