[debian-mysql] Bug#1088133: Bug#1088133: mariadb-server: passwordless root doesn't survive restores

[Otto Kekäläinen]

Hi!

> First of all - the mariadb packages are really great, and the new
> passwordless root setup is awesome, thanks for all your work.

Thanks! We debuted it in Debian 10 years ago, and since both upstream
MariaDB and MySQL started using it everywhere.

> One small thing though - If you use `mysqldump` from a version prior
> to passwordless root, and then restore that on a new installation,
> you lose the passwordless root account, and restore the debian-sys-maint
> and passworded-root accounts.
>
> While this is obvious and not really a bug, it seems like a common
> situation that can cause lots of confusion (took me a while to figure
> out what was going on) and it would be really great if the
> README.Debian.gz could document how to properly restore the correct
> settings (maybe even a simple script that could be run).

You are right, this corner case isn't automated nor have we good advice.

Suggestions welcome! It is not specific to Debian, so you can file
Jira or send PR upstream, and if it is merged on latest upstream
development version we can backport it in Debian for all users.

Alternatively you can submit a Debian-only README update at
https://salsa.debian.org/mariadb-team/mariadb-server/