[mythtv-users] mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade

[Ken Yee]

Found a lot of stories of this:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)But the solutions mentioned didn't help.my /etc/mythtv/config.xml is not a symlink (apparently systemd can't find symlinks)
I verified the mysql passwords for the mythtv user are all the same in that config file, the ~mythtv/.mythtv/config.xml and ~/.mythtv/config.xml files
I verified that doing:
mysql -u mythtv mythconverg -p
and typing in the password in those files works fine.mysql -u mythtv -h 127.0.0.1 mythconverg
also works fine.
But mythsetup is always stuck on the above.
BTW, for anyone upgrading to Ubuntu 20.04, MariaDB will timeout on startup because Ubuntu's new AppArmor feature...follow the bug report tip here to fix that:
https://stackoverflow.com/questions/40997257/mysql-service-fails-to-start-hangs-up-timeout-ubuntu-mariadb

ken
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201011/f93081c3/attachment.htm>