[mythtv-users] About updating from Ubuntu 24.04 to 26.04

[Gary Buhrmaster]

On Thu, May 7, 2026 at 3:12 AM Bill Meek <keemllib at gmail.com> wrote:

> 1. In MySQL, the mysql_native_password is going away.

And, from a security perspective, that is basically good,
as the passwords are not stored in a properly secured
format with "native"

> That is the original
> issue I was trying to solve. And it's done for a new MythTV install. I haven't figured out
> where to switch to the new (and default) caching_sha2_password for existing
> users.

It is, of course, complicated, because both the server
must support the new encryption, and the clients
must also support the new encryptions, and that
will probably require db admins to force a password
reset at some future date when all have been
updated so the new encryptions are stored and
available.

> At some point, if the native plugin goes away, access to the MythTV
> DB would be lost.

I suspect (but have not followed Oracle's plans), that
fully removing native capability is going to be many
years away, because not all client connectors are
going to be able to be changed quickly.  They might
force one to explicitly continue to enable native, but
not allowing it at all seems unlikely any time soon.

> MariaDB continues to use the native password although
> they claim to allow the caching one, but only for conversions, so I'm not
> changing anything with MariaDB in our packaging.

MariaDB is moving from native password to parsec (with
parsec being the new default for MariaDB at some future
version), and supporting sha2 for compatibility to, and
connection to (and transition from) mysql[0].  It, too, will
likely continue to support native for quite a long time.




[0] Canonical defaults to mysql due to a "marketing
agreement" with Oracle, which means someone
(Oracle most likely) is paying someone else (Canonical
most likely) to promote mysql.  Without such marketing
argeements no other distro with any market share
seems to still default to mysql rather than mariadb,
but money talks.