[mythtv-users] mythtv setup can't talk to mysql/mariadb after ubuntu 20.04 upgrade
kenkyee at yahoo.com
Sun Oct 11 15:14:55 UTC 2020
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:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users