aerospot.blogg.se - Debian install mysql

DEBIAN INSTALL MYSQL HOW TO
DEBIAN INSTALL MYSQL UPDATE
DEBIAN INSTALL MYSQL DRIVER
DEBIAN INSTALL MYSQL FULL
DEBIAN INSTALL MYSQL PASSWORD

You can verify checking the configuration: cat /etc/mysql//default-auth-override.cnf Sudo DEBIAN_FRONTEND=noninteractive apt install mysql-server "mysql-community-server mysql-server/default-auth-override select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)"

DEBIAN INSTALL MYSQL PASSWORD

"mysql-community-server mysql-community-server/re-root-pass password tiger" "mysql-community-server mysql-community-server/root-pass password tiger"

DEBIAN INSTALL MYSQL UPDATE

To recap, the following will install the MySQL Server non-interactively, setting the root password to ‘tiger’, and enabling the legacy authentication method: sudo apt update

a single space (or tab) around the word select.

single space (or tab) between mysql-community-server and mysql-server/.

It’s quite a long string, and you have to be careful with the format, your you will have lots of fun debugging: When doing an non-interative install, and you want the legacy method, you have to do the following before doing the apt install mysql-server: sudo debconf-set-selections <<< "mysql-community-server mysql-server/default-auth-override select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)" The latter is preferred, but it can be tedious. If you however have systems, applications, or MySQL drivers, which do not support the new method, you can either: Possible reason, and also a good reason, is that it is good for new installations to use the newer, more secure method. This last step is not documemented (at the time of writing) in the MySQL Documentation.

and new: choose the authentication method.

The above commands will install the server, but require you to: Interaction is required when you install the MySQL server. Non-Interactive Installation of MySQL Server 8.0

DEBIAN INSTALL MYSQL FULL

At the end of the post you have the full playbook in which we do it all using Ansible. The above commands can be easily scripted, and no interaction is needed. The other way is to simple create the file /etc/apt//mysql8.list: echo "deb $(lsb_release -sc) mysql-8.0" | \ You could use add-apt-repository, but it would mean installing yet again more dependencies. # Note: key 5072E1F5 is MySQL official's (always double check!) Sudo apt-key adv -keyserver -recv-keys 5072E1F5 In the following steps, we do not download the mysql-apt-repo package, instead we do whatever it does, manually: sudo apt install -y dirmngr The following is inspired by the MySQL Documentation under A Quick Guide to Using the MySQL APT Repository and Adding and Configuring the MySQL APT Repository Manually. First, Set Up Official MySQL APT Repository You need the “legacy” plugin which can be set globally in the configuration or, more preferably, when creating the database user. If you are using Go, the new default authentication of MySQL 8.0 does not work yet. Whether that is a documetation bug is open for discussion. The first two screens are not new the 3rd is, and it is not documented. There are currently two interactive questions being asked: Especially with Group Replication, where you need a minimal of 3 servers. Installing a single MySQL server is easy, but once you have done it, the fun starts to fade after a dozen or so times doing it.

You can also do such unattended installs for each application. It also shows the extra step to keep using the legacy MySQL authentencation method.īonus: Ansible playbook included! Unattended Debian Installationĭebian comes with debconf which can be used to do install the whole distribtion non-interactively without a (virtual) monitor attached.

DEBIAN INSTALL MYSQL HOW TO

This post will show how to install MySQL 8.0 on a Debian 9 using the official MSQL APT repositories. If you start new, and you can, stick to the new method.

DEBIAN INSTALL MYSQL DRIVER

If you are using a MySQL driver which has no support yet for strong password encryption (for example the go-sql-driver/mysql package driver), or you “need” to switch to MySQL 8.0 and keep previous user accounts intact, you will want to set the default back to the mysql_native_plugin for authentication. The missing part is the extra question during the installation of the server whether you want to keep using the new default authentention method, or use the (now) legacy native method. One of the stacks we are enrolling is MySQL Group Replication, which requires at least 3 servers.Īlthough the MySQL Documentation show how to install MySQL non-interactively, it is not entirely complete. To make things easier and automated, we can use the non-interactive feature of the Debian packaging system to deploy services. At work we are doing quite a bit with Debian.