id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 13576 fixes/31 mythweb on Xubuntu 20.04 LTS Daily Build Mike Bibbings Bill Meek "Built debs locally using mythtv/packaging/deb/ and installed mythtv. Basics work, channel scanning (HD HomeRun Quattro) Live TV, Recordings. mythweb does not work, something to do with mysql 8 in focal. mythtv user has been created with default of caching_sha2_password {{{ mysql> select host,user,plugin from user where user=""mythtv""; +------+--------+-----------------------+ | host | user | plugin | +------+--------+-----------------------+ | % | mythtv | caching_sha2_password | +------+--------+-----------------------+ 1 row in set (0.00 sec) }}} Confirmed my suspicion by manually changing user mythtv in mysql {{{ ALTER USER 'mythtv'@'%' IDENTIFIED WITH mysql_native_password BY 'password from /etc/mythtv/config.xml'; }}} and rebooting, after which mythweb works. I believe mc.sql (in mythtv) and mythtv-database.postinst need changing for mysql 8 to make sure mysql_native_password is used, alternatively fix mythweb so it works with caching_sha2_password or mysql_native_password (I have no idea on how to do this!). Note: trac needs updating to allow Version v31-fixes to be selected. Mike " Bug Report - General closed minor 31.0 Plugin - MythWeb v31-fixes medium fixed 0