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

[Bill Meek]

On Tuesday 05 May 2026 07:14:52 PM (-05:00), Will Dormann wrote:
 > On 5/5/26 6:01 PM, Bill Meek wrote:
 > mysql> SELECT user,host,plugin FROM user;
 > +------------------+-----------+-----------------------+
 > | user             | host      | plugin                |
 > +------------------+-----------+-----------------------+
 > | mythtv           | %         | mysql_native_password |
 > | root             | 127.0.0.1 | mysql_native_password |
 > | root             | ::1       | mysql_native_password |
 > | root             | kapok     | mysql_native_password |
 > | debian-sys-maint | localhost | auth_socket           |
 > | mysql.infoschema | localhost | caching_sha2_password |
 > | mysql.session    | localhost | caching_sha2_password |
 > | mysql.sys        | localhost | caching_sha2_password |
 > | mythtv           | localhost | mysql_native_password |
 > | root             | localhost | mysql_native_password |
 > +------------------+-----------+-----------------------+

OK, good that some of the user/host combinations are now 
caching_sha2_password.

Stephen just posted the root cause of the issue (of being able to
use sudo mysql).

Mine entry for that looks like this, I WOULDN'T just try changing/
adding this yet:

+------+-----------+-------------+-----------------------+
| user | host      | plugin      | authentication_string |
+------+-----------+-------------+-----------------------+
| root | localhost | auth_socket |                       |
+------+-----------+-------------+-----------------------+

Does this (another method used by MythTV packaging):

     sudo mysql --defaults-file=/etc/mysql/debian.cnf mysql

Expect the prompt for sudo and then a mysql> prompt.

I'm assuming that 100% of these tests have been the host that has
the database on it, and probably MythTV too.

-- 
Bill