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

[Roland Ernst]

On Wed, May 6, 2026 at 2:16 AM Will Dormann <wdormann at gmail.com> wrote:

> 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
>
>
Hi Will,

Bill and myself are looking for a common scenario of updating MythTV for
MariaDB and MySQL.
In the file "mysql-server.postinst" used by install/updating the MySQL
server on Ubuntu, I see a statement like

      echo "CREATE USER 'debian-sys-maint'@'localhost' IDENTIFIED WITH
'auth_socket' AS 'root';" >> "$initfile"
      echo "GRANT ALL ON *.* TO 'debian-sys-maint'@'localhost' WITH GRANT
OPTION;" >> "$initfile"

This means that the mysql user 'debian-sys-maint' may use root credentials
to log into the MySQL shell
Please do this check for confirmation:
      sudo mysql -u debian-sys-maint

This should give you a MySQL shell with root privileges without supplying
the credentials file
by the command line option "--defaults-file=/etc/mysql/debian.cnf"

Would you please so kind and check if this works as well ?

Regards,
Roland
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20260519/3d80ce6e/attachment.htm>