I finally decided to update my myth box from 7.10 to 10.10 yesterday. During installation I selected that the backend may be used by other frontends and also that there might be other backends that this machine would use (can't remember exactly how it's worded).
Now, no matter what I try, the frontend cannot connect to the local backend. And...the backend setup can't connect to the database unless I use the root user/pw. I can use mysql client in terminal to login as the mythtv user, but for whatever reason, the setup requires root. I'm also getting the "No UPnP Backends" message in setup when I've got the mythtv user/pw in there instead of the root user/pw.
Now the completely insane thing is that the frontend can't connect to the backend regardless of the db settings (root or mythtv).
my router consistently gives this machine the ip 192.168.1.103, and that was pre-populated in a lot of places when I ran setup the first time. Tuner card, schedules direct and everything else set up ok, but the frontend won't connect.
In the quasi-terminal window that pops up when setup runs I see a "can't connect to database error" and "Driver error was [1/1045]" and "Access denied for user 'mythtv'@'MythTV-Lido' (using password: YES)".
I've checked ~.mythtv/mysql.txt and /etc/mythtv.txt and config.xml too. All have the right ipaddress, port username and pw for the database (192.168.1.103, 3306 and mythtv).
Any idea what to try next? I'd hate to have to reinstall for THIS, though sometimes that seems to be the only way to make some problems go away.