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

[Will Dormann]

On 5/5/26 6:01 PM, Bill Meek wrote:
> These commands and their output please, using the sudo password, not 
> MythTV's:
> 
> sudo -k
> sudo cat /etc/mysql/debian.cnf | sed -e "s/password.*/password = was here/"
> sudo -k
> sudo mysql

wd at jerky:~$ sudo -k
wd at jerky:~$ sudo cat /etc/mysql/debian.cnf | sed -e 
"s/password.*/password = was here/"
[sudo: authenticate] Password:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
socket   = /var/run/mysqld/mysqld.sock
wd at jerky:~$ sudo -k
wd at jerky:~$ sudo mysql
[sudo: authenticate] Password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
password: NO)
wd at jerky:~$



> 
> If the last one fails, use the same method you did before to
> get the output of: SELECT user,host,plugin FROM user;

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 |
+------------------+-----------+-----------------------+
10 rows in set (0.00 sec)

mysql>



-WD