• Home
  • Linux
  • Ubuntu
  • Debian
  • CentOS
  • Linux Commands
  • About Us
  • Donate
TecNStuff
Menu
  • Home
  • Linux
  • Ubuntu
  • Debian
  • CentOS
  • Linux Commands
  • About Us
  • Donate

How to Install MySQL on Debian 11

Written by Admin, Updated On January 9, 2023
debian, mysql
How to Install MySQL on Debian 11

MySQL is free and most widely open-source database management system. MySQL is no longer available since release of Debian 10 and MariaDB has become the default database system. MariaDB is the default database system in Debian 11. This tutorial will describe how to install MySQL on Debian 11 from the MySQL Apt repository.

How to Install MySQL on Debian 11#

Follow the below given steps to install MySQL on your Debian 11 system:

Step 1 – Download Repositories

At first, we will download the latest MySQL release package from MySQL official PPA of Debian using wget command. Run the below given command to add the MySQL APT repository to your system:

wget http://repo.mysql.com/mysql-apt-config_0.8.24-1_all.deb

Step 2 – Add MySQL Repositories

Once the package download completed, install the release package with root or user with sudo privileges:

sudo apt install ./mysql-apt-config_0.8.24-1_all.deb

It will prompt you to configuration menu where you can select MySQL version whatever you want like below:

debian-select-mysql-version

By default, MySQL 8.0 is selected. You can install another version by selecting MySQL Server & Cluster (Currently selected: mysql-8.0) option and choose version as per your requirement. In this guide, we will install MySQL 8.0 so select the last option Ok and hit Enter key to save changes.

Step 3 – Install MySQL

At this step, your system is ready to install MySQL. First, you need to update the package list using:

sudo apt update

Use the below command to install MySQL server on your Debian system:

sudo apt install mysql-server

It will prompt to set root user password as below. Enter a strong password for root user and hit Ok button. Again, It will ask to re-enter password. This password will be use as root user password.

Next, you will be presented with a message informing you about the new MySQL 8 authentication.

After that, it will prompt with a message informing you about the new MySQL 8 authentication. Before selecting the default MySQL 8 authentication plugin make sure it is supported by your application.

debian-mysql-select-authentication

Step 4 – Verify Installation

It will start the MySQL service automatically once the installation is completed. To check the MySQL service status issue below given command:

sudo systemctl status mysql

It should show below output if service active:

● mysql.service - MySQL Community Server
    Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
    Active: active (running) since Thr 2022-11-25 16:40:45 UTC; 20s ago
    ...

Step 5 – Secure MySQL Installation

You can improve MySQL security by execute the mysql_secure_installation command. It’s a MySQL inbuilt security script. Run then below command:

sudo mysql_secure_installation

Once you execute this command it will prompt you to enter root user password which you set before this step. After that, it will ask you to choose whether to use the VALIDATE PASSWORD PLUGIN or not, which can be use to test the strength of your MySQL password. Press ENTER if you don’t want to set up the validate password plugin.

Next, It will ask if you want to change current root user password. If your current password is perfect then, enter N for No at the prompt.

Now, for all next questions press Y and hit Enter key for each. This will remove some anonymous users and test database, disable remote root logins and load these new rules so that MySQL immediately respects the changes you have made. Following questions will be prompt and you have to press yes/y for all :

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

Step 5 – Connect MySQL

You can login to MySQL server using command line using below command:

mysql -u root -p

It will prompt to enter root user password which you set before and it will show you output as below:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.31 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Conclusion#

You learned how to install MySQL 8.0 and Secure MySQL on Debian 11 Bullseye. You should stick to MariaDB the default database system of Debian 11.

Feel free to leave a comment below, if you are facing any issue.

If our content helps you, please consider buying us a coffee

Thank you for your support.

Share On
Share on Facebook
Share on Twitter
Share on Reddit
Share on Tumblr
 Previous Article How to Install MySQL on Ubuntu 22.04
Next Article   How to Install Gradle on Debian 11

Related Posts

  • How to Change Hostname Debian 11

    How to Change Hostname on Debian 11

    February 3, 2023
  • How to Install Python 3.11 on Debian 11

    How to Install Python on Debian 11

    January 25, 2023
  • How to Install Mongodb on Debian 11

    How to Install MongoDB on Debian 11 Linux

    January 11, 2023

Leave a Reply Cancel reply

DigitalOcean Referral Badge

Popular Posts

  • How to Install SSH Keys on Ubuntu 22.04
    How to Set up SSH Keys on Ubuntu 22.04 January 7, 2023
  • How to Install Mongodb on Debian 11
    How to Install MongoDB on Debian 11 Linux January 11, 2023
  • How to Install Puppet Agent on Ubuntu 22.04
    How to Install Puppet Agent on Ubuntu 22.04 January 22, 2023
  • How to Install Jenkins on Debian 11
    How to Install Jenkins on Debian 11 January 5, 2023
  • How to Change-Hostname Ubuntu 22.04
    How to Change Hostname on Ubuntu 22.04 January 19, 2023
© 2020 TecNStuff All rights reserved. This website is using and storing cookies on your browser. By using this website you agree our Privacy Policy.  Follow us -  Twitter | Facebook