Debian 9 - Install MySQL Server
The steps below will show you how to install whichever version of MySQL-server you want on your Debian 9 server and why you should not just run
sudo apt install mysql-server -y
Usually, to install MySQL on a distro, you would just perform the following commands:
sudo apt update sudo apt install mysql-server -y
You would then receive either MySQL 5.5, 5.6, or 5.7 depending on which distro you were using, but they were all versions of MySQL. However, with Debian 9, if you do this you will end up installing MariaDB 10.1 which is a drop in replacement for 5.6.
sudo mysql and then use mysql command to set the password:
GRANT ALL ON *.* TO root@localhost identified by 'myawesomepassword';
Install MySQL 5.6, 5.7, or 5.8-preview
If you really want MySQL instead of MariaDB for whatever reason, you can execute the script below to install the version you want.
#!/bin/bash cd /tmp wget https://dev.mysql.com/get/mysql-apt-config_0.8.7-1_all.deb sudo dpkg -i mysql-apt-config_*.deb
At the popup-page, select the version you want.
Then use the following commands to install the MySQL server (it will install the version you selected).
sudo apt update sudo apt install mysql-community-server -y
First published: 16th August 2018