![\"Debian](\"https:\/\/dbahire.com\/wp-content\/uploads\/2017\/06\/debian-ying-yang.png\" "\\"To")
<\/p>\n
In the latest stable version of Debian, if you ask to install mysql-server, you now get installed mariadb automatically, with no (evident) way of installing Oracle’s MySQL. Any major version upgrade has to be done carefully (not only for MariaDB, but also for MySQL and Postgres), and I bet that a MySQL 5.5 to MariaDB 10.1 will cause a huge confusion. Not only it will fail user expectations, I think this will cause large issues now that MariaDB has chosen to become a “hard” fork, and become incompatible in many ways with MySQL. Not only the server upgrade will cause user struggle, the connector is probably going to cause pain to users (as it has already been noticed in some of my infrastructure).<\/p>\n
In order to try to be helpful for those MySQL users that may be looking for help, here is how to install and setup MySQL server in Debian 9 “Stretch”, using MySQL upstream repo. The commands shown above may not be the best course of action on all cases (be careful when downloading things from then Internet), and as a disclaimer, you should read the official documentation on how to use Oracle’s MySQL apt repository<\/a> in advance. The following is a more verbose, step-by step explanation, plus some extended explanations on why I chose to recommend this method in particular (and its disadvantages).<\/p>\n Install Oracle’s APT Repositories<\/strong><\/p>\n MySQL Release Engineering team provides ready-to-use apt repositories with most of it software, including the server and many of its utilities. To enable the server repository, edit your apt sources file (or better, create a new one by executing:<\/p>\n And add the following lines:<\/p>\n Here, I have chosen to install MySQL 5.7, but 5.6 and 8.0 (not yet stable as of June 2017) are also available for Debian stable. You can also chose to enable Before starting to use the repo, you have to add the repo public key as trusted, for that I suggest:<\/p>\n RPM and APT repos seem to share the GPG key, and that is at https:\/\/repo.mysql.com\/RPM-GPG-KEY-mysql (it is the same one that If you run The advantages of using a repository rather than a one-time install is that you will get automatic updates for minor versions that may correct bugs and security issues (with minimal feature changes).<\/p>\n<\/li>\n Refresh your available package list<\/strong><\/p>\n Just run:<\/p>\n You should see a reference to Install MySQL Server<\/strong>:<\/p>\n\n
# nano \/etc\/apt\/sources.list.d\/mysql.list<\/pre>\n
\r\ndeb http:\/\/repo.mysql.com\/apt\/debian\/ stretch mysql-5.7\r\ndeb-src http:\/\/repo.mysql.com\/apt\/debian\/ stretch mysql-5.7\r\n<\/pre>\n
mysql-tools<\/code> (normally here they add the connectors, mysql-router and the mysql-utilities, but right now it is empty) and mysql-apt-config<\/code> the repo where the automatic apt configurator package is. While the mysql-apt-config<\/code> utility is nice to have, I like to have control over my repositories manually, even if that means having to do this again in the future.<\/p>\n\r\n# wget -O \/tmp\/RPM-GPG-KEY-mysql https:\/\/repo.mysql.com\/RPM-GPG-KEY-mysql\r\n# apt-key add \/tmp\/RPM-GPG-KEY-mysql\r\n<\/pre>\n
mysql-apt-config<\/code> utility adds automatically on install). Not doing so will not make the rest of the install fail, but it will warn you due to the lack of a signed key.<\/p>\napt-key list<\/code> you will see a new trusted key for apt:<\/p>\n\r\n# apt-key list \r\n\/etc\/apt\/trusted.gpg\r\n--------------------\r\npub dsa1024 2003-02-03 [SCA] [expires: 2019-02-17]\r\n A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5\r\nuid [ unknown] MySQL Release Engineering
\r\n# apt update\r\nIgn:1 http:\/\/softlibre.unizar.es\/debian stretch InRelease\r\nHit:2 http:\/\/softlibre.unizar.es\/debian stretch-updates InRelease\r\nHit:3 http:\/\/security.debian.org\/debian-security stretch\/updates InRelease\r\nHit:4 http:\/\/softlibre.unizar.es\/debian stretch Release \r\nGet:5 http:\/\/repo.mysql.com\/apt\/debian stretch InRelease [14.2 kB] \r\nGet:7 http:\/\/repo.mysql.com\/apt\/debian stretch\/mysql-5.7 Sources [870 B]\r\nGet:8 http:\/\/repo.mysql.com\/apt\/debian stretch\/mysql-5.7 amd64 Packages [5,643 B]\r\nFetched 20.7 kB in 6s (3,320 B\/s) \r\nReading package lists... Done\r\nBuilding dependency tree \r\nReading state information... Done\r\nAll packages are up to date.\r\n<\/pre>\n
repo.mysql.com<\/code> with no errors. You probably have other main repos or pending updates, that is ok.\n<\/li>\n\r\n# apt install mysql-server\r\nReading package lists... Done\r\nBuilding dependency tree \r\nReading state information... Done\r\nThe following additional packages will be installed:\r\n libaio1 libatomic1 libmecab2 libnuma1 mysql-client mysql-community-client\r\n mysql-community-server\r\nThe following NEW packages will be installed:\r\n libaio1 libatomic1 libmecab2 libnuma1 mysql-client mysql-community-client\r\n mysql-community-server mysql-server\r\n0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.\r\nNeed to get 36.7 MB of archives.\r\nAfter this operation, 253 MB of additional disk space will be used.\r\nDo you want to continue? [Y\/n] Y\r\nGet:1 http:\/\/repo.mysql.com\/apt\/debian stretch\/mysql-5.7 amd64 mysql-community-client amd64 5.7.18-1debian9 [8,859 kB]\r\nGet:2 http:\/\/softlibre.unizar.es\/debian stretch\/main amd64 libaio1 amd64 0.3.110-3 [9,412 B]\r\nGet:3 http:\/\/softlibre.unizar.es\/debian stretch\/main amd64 libatomic1 amd64 6.3.0-18 [8,920 B]\r\nGet:4 http:\/\/softlibre.unizar.es\/debian stretch\/main amd64 libnuma1 amd64 2.0.11-2.1 [33.3 kB]\r\nGet:5 http:\/\/softlibre.unizar.es\/debian stretch\/main amd64 libmecab2 amd64 0.996-3.1 [256 kB]\r\nGet:6 http:\/\/repo.mysql.com\/apt\/debian stretch\/mysql-5.7 amd64 mysql-client amd64 5.7.18-1debian9 [12.6 kB]\r\nGet:7 http:\/\/repo.mysql.com\/apt\/debian stretch\/mysql-5.7 amd64 mysql-community-server amd64 5.7.18-1debian9 [27.5 MB]\r\nGet:8 http:\/\/repo.mysql.com\/apt\/debian stretch\/mysql-5.7 amd64 mysql-server amd64 5.7.18-1debian9 [12.6 kB]\r\nFetched 36.7 MB in 4s (8,495 kB\/s) \r\nPreconfiguring packages ...\r\nSelecting previously unselected package libaio1:amd64.\r\n(Reading database ... 27516 files and directories currently installed.)\r\nPreparing to unpack ...\/0-libaio1_0.3.110-3_amd64.deb ...\r\nUnpacking libaio1:amd64 (0.3.110-3) ...\r\nSelecting previously unselected package libatomic1:amd64.\r\nPreparing to unpack ...\/1-libatomic1_6.3.0-18_amd64.deb ...\r\nUnpacking libatomic1:amd64 (6.3.0-18) ...\r\nSelecting previously unselected package libnuma1:amd64.\r\nPreparing to unpack ...\/2-libnuma1_2.0.11-2.1_amd64.deb ...\r\nUnpacking libnuma1:amd64 (2.0.11-2.1) ...\r\nSelecting previously unselected package mysql-community-client.\r\nPreparing to unpack ...\/3-mysql-community-client_5.7.18-1debian9_amd64.deb ...\r\nUnpacking mysql-community-client (5.7.18-1debian9) ...\r\nSelecting previously unselected package mysql-client.\r\nPreparing to unpack ...\/4-mysql-client_5.7.18-1debian9_amd64.deb ...\r\nUnpacking mysql-client (5.7.18-1debian9) ...\r\nSelecting previously unselected package libmecab2:amd64.\r\nPreparing to unpack ...\/5-libmecab2_0.996-3.1_amd64.deb ...\r\nUnpacking libmecab2:amd64 (0.996-3.1) ...\r\nSelecting previously unselected package mysql-community-server.\r\nPreparing to unpack ...\/6-mysql-community-server_5.7.18-1debian9_amd64.deb ...\r\nUnpacking mysql-community-server (5.7.18-1debian9) ...\r\nSelecting previously unselected package mysql-server.\r\nPreparing to unpack ...\/7-mysql-server_5.7.18-1debian9_amd64.deb ...\r\nUnpacking mysql-server (5.7.18-1debian9) ...\r\nSetting up libatomic1:amd64 (6.3.0-18) ...\r\nSetting up libnuma1:amd64 (2.0.11-2.1) ...\r\nSetting up libmecab2:amd64 (0.996-3.1) ...\r\nProcessing triggers for libc-bin (2.24-11+deb9u1) ...\r\nSetting up libaio1:amd64 (0.3.110-3) ...\r\nProcessing triggers for systemd (232-25) ...\r\nProcessing triggers for man-db (2.7.6.1-2) ...\r\nSetting up mysql-community-client (5.7.18-1debian9) ...\r\nSetting up mysql-client (5.7.18-1debian9) ...\r\nSetting up mysql-community-server (5.7.18-1debian9) ...\r\nSetting up mysql-server (5.7.18-1debian9) ...\r\nProcessing triggers for libc-bin (2.24-11+deb9u1) ...\r\n<\/pre>\n