{"id":1645,"date":"2020-11-14T22:40:35","date_gmt":"2020-11-14T22:40:35","guid":{"rendered":"https:\/\/linuxways.net\/?p=1645"},"modified":"2020-11-18T17:27:03","modified_gmt":"2020-11-18T17:27:03","slug":"how-to-install-the-latest-mysql-in-debian-10","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/debian\/how-to-install-the-latest-mysql-in-debian-10\/","title":{"rendered":"How to install the latest MySQL in Debian 10"},"content":{"rendered":"

MySQL is a well-known and open-source relational database management system that is pre-installed on Linux Debian\u2019s repository. MariaDB is available as the default database in Debian 10. Therefore, you need to install the MySQL server with all its dependencies on your Debian 10 system.<\/p>\n

In this article, we will give you a demo on how to install the MySQL server on Debian 10.<\/p>\n

Prerequisite<\/strong><\/h2>\n

You have sudo command access to run the administrative tasks.<\/p>\n

The following steps you need to follow to install the MySQL server on your Debian 10 system:<\/p>\n

Step 1: Open a terminal<\/strong><\/h2>\n

Click on the \u2018Activities\u2019 and then enter the terminal in the application search bar. Click on the terminal icon which will be displayed under the search bar:<\/p>\n

<\/p>\n

Step 2: Add or Configure MySQL Repository in Debian 10\u00a0<\/strong><\/h2>\n

For the installation of MySQL, you need to first add the MySQL apt repository to your Debian 10 system. For this purpose, go to the download page of the repository and grab the latest release of the MySQL package by using the below-mentioned wget command:<\/p>\n

$ wget http:\/\/repo.mysql.com\/mysql-apt-config_0.8.13-1_all.deb<\/a><\/pre>\n
<\/p>\n
Once the download of the latest release package is completed, install it by executing the following command with sudo privileges:<\/p>\n
$ sudo apt install .\/mysql-apt-config_0.8.13-1_all.deb<\/pre>\n
<\/p>\n
During the installation, the configuration menu will be displayed on the system where you can select the MySQL version that you want to install. Here, MySQL 8.0 is already selected. You can select other versions according to your server requirements. Now, select \u2018OK\u2019 by pressing the \u2018Tab\u2019 key\u00a0 and hit \u2018Enter\u2019 that is also shown in the below-displayed image:<\/p>\n
<\/p>\n
Step 3: Update apt package list<\/strong><\/h2>\n
The recommended method is to update the repository packages list before installing any new application on your system. Therefore, update apt packages by using the following command:<\/p>\n
$ sudo apt update<\/pre>\n
Step 4: Install MySQL\u00a0<\/strong><\/h2>\n
After updating the Debian apt repository, you will execute the below-given command to install the MySQL server packages on Debian 10:<\/p>\n
$ sudo apt install mysql-server<\/pre>\n
<\/p>\n
Here, you will be asked to enter the MySQL root user password. Leave it blank that will set further in this article.<\/p>\n
<\/p>\n
In the next dialog, a message will display on the system in order to inform you about the MySQL 8.0 authentication.<\/p>\n
<\/p>\n
First, make sure that this authentication plugin is supported by your MySQL application, and then select the MySQL 8 authentication plugin.<\/p>\n
<\/p>\n
Step 5: Check Status of MySQL Service\u00a0<\/strong><\/h2>\n
Once the installation process is completed, MySQL services will automatically start on your system. You can check service running status by typing the following command:<\/p>\n
$ sudo systemctl status mysql<\/pre>\n
<\/p>\n
Step 6: Make secure installation of MySQL<\/strong><\/h2>\n
By executing the following command you can make the installation of the MySQL server more secure. Here, you need to set the root account password as follows:<\/p>\n
$ sudo mysql_secure_installation<\/pre>\n
<\/p>\n
In the next step, you will be prompted to configure the \u2018VALIDATE PASSWORD PLUGIN\u2019. This plugin is usually used to test the MySQL user\u2019s password strength. It consists of three levels for password validation: low, medium, and strong. If you don\u2019t want to configure this plugin the hit \u2018Enter\u2019.<\/p>\n
In the next stage, you will set the root user MySQL account password.<\/p>\n
Once you have been entered the root account password, the script will ask you to answer the following questions:<\/p>\n
    \n
  1. Are you want to remove the anonymous user?<\/li>\n
  2. Are you want to restrict the of root user\u00a0access to the local machine?<\/li>\n
  3. Want to remove the test database?<\/li>\n<\/ol>\n
    You should be response (yes) press \u2018y\u2019 to all questions in order to successfully complete the secure configuration.<\/p>\n
    <\/p>\n
    Step 7: Connect to the MySQL Server<\/strong><\/h2>\n
    To work on the MySQL database, a necessary package MySQL client is required that is pre-installed as a dependency of the MySQL server package during the installation process.<\/p>\n
    During the installation, if you have selected and installed the default authentication method for root login type then, run the following command:<\/p>\n
    $ sudo mysql<\/pre>\n
    <\/p>\n
    For legacy authentication method, type the following command on the terminal:<\/p>\n
    $ mysql -u root -p<\/pre>\n
    <\/p>\n
    You will be asked to enter the root account password which you have set in the above step mysql_secure_installation. Once you have entered the password, MySQL shell environment will display on the terminal.<\/p>\n
    Conclusion<\/strong><\/h2>\n
    In this article, we have given the complete details about how to install MySQL server on Debian 10 Linux system. Moreover, we have also seen how to secure the installation and connect with the MySQL shell. Using the Validate password plugin you can make a more secure database MySQL password authentication.<\/p>\n
    This post will help you in installing PostgreSQL on Linux Mint 20.<\/a><\/p>","protected":false},"excerpt":{"rendered":"
    MySQL is a well-known and open-source relational database management system that is pre-installed on Linux Debian\u2019s repository. MariaDB is available as the default database in Debian 10. Therefore,…<\/p>","protected":false},"author":2,"featured_media":1663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[17,27],"class_list":["post-1645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","tag-debian-10","tag-mysql"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/1645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=1645"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/1645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/1663"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=1645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=1645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=1645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}