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

[jam at tigger.ws]

On Tuesday, May 5, 2026 10:20:37 AM Australian Western Standard Time Will 
Dormann wrote:
> On 5/4/26 10:02 PM, Bill Meek wrote:
> > What does these 2 return please:
> >      mysql --version
> >      sudo mysql --execute "SELECT user,host,plugin FROM user WHERE
> > 
> > user='mythtv'" mysql
> 
> After upgrading to 26.04, it's:
> 
> mysql  Ver 8.4.8-0ubuntu1 for Linux on x86_64 ((Ubuntu))
> 
> And the 2nd command fails as at least on my system it requires the
> password specified in my config.xml file.  But with such auth:
> 
> mysql> SELECT user,host,plugin FROM user WHERE user='mythtv'
>      -> ;
> +--------+-----------+-----------------------+
> 
> | user   | host      | plugin                |
> 
> +--------+-----------+-----------------------+
> 
> | mythtv | %         | mysql_native_password |
> | mythtv | localhost | mysql_native_password |
> 
> +--------+-----------+-----------------------+

Will that's very bad, and not what my clean 26.04 does. Being a unix greybeard 
I have a root passwd and visudo says rootpw (and vim :-) but
> >      sudo mysql --execute "SELECT user,host,plugin FROM user WHERE 
user='mythtv'" mysql
asks for ROOT password as it ought.
Are you certain about your sudo mysql ... ie su mysql ... would give quite 
different results
James