On Monday 30 July 2018 at 13:45:26, Alexander Bochmann wrote:
> Hi,
>
> I recently updated an old (former) Debian system from Devuan
> jessie to ascii.
>
> As it turns out, its MySQL database still had a root password
> in the (very) old format, which isn't accepted by MariaDB. The
> upgrade routine doesn't handle that problem, leading to followup
> errors.
I believe the same happens on Debian Jessie -> Stretch.
> I had to manually start MariaDB with --skip-grant-tables,
> update mysql.user with a root password using the new hash format,
> and then complete the dist-upgrade.
>
> > update mysql.user set Password = password('admin_pw') where User =
> > 'root' and Host = 'localhost'; flush privileges;
>
> No other major problems on a system with over 1500 installed
> packages (ok, insserv reenabled dependency based boot without
> asking, but that unexpectedly didn't break anything).
>
> Good work on that release!
I'm impressed too :)
Antony.
--
Neurotics build castles in the sky;
Psychotics live in them;
Psychiatrists collect the rent.
Please reply to the list;
please *don't* CC me.
_______________________________________________
Dng mailing list
Dng@lists.dyne.org
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
