I upgraded from v32 to v33 today, and it hosed up my mysql permissions (without aborting the upgrade, lucky I happened to look at that window just in time to catch the error). I need to post details separately, as I'm not the first to see this, but it would not surprise me if the db/user(s) never got configured properly during the OP's install.
I've never ran mythconverg_restore, always just used mysql directly, so I could be way off base here, but I know restoring with sudo w/o that script would be possible even w/o a mythtv user configured.
Personally, the first thing I'd do is to select user,host from mysql.user and see if 'mythtv'@'MediaPC.local' (and/or 'maybe even 'mythtv'@'%') even exists. But then, I'm no expert.
P.S. The error looked like this. I thought it was just omitting some of the data from the log, but no, it actually did create a user '' with host '%'. Looks to me like it's missing at least "mythtv", "mythtv", and "mythconverg", and I can't say I'm crazy about using '%';
Code: Select all
Setting up mythtv-database (2:33.1+fixes.202302200304.c273ed0f9a~ubuntu22.04.1) ...
mysql 'hidden SECURITY_INFO' --execute=CREATE USER IF NOT EXISTS ''@'%' IDENTIFIED WITH mysql_native_password; ALTER USER ''@'%' IDENTIFIED BY ''; GRANT ALL ON .* TO ''@'%'; failed, (incorrect admin username/password or syntax?)
Try:
sudo dpkg-reconfigure mythtv-database