[mythtv-users] Mythfrontend on Android-database access

[Stephen Worthington]

On Sun, 15 May 2022 13:11:27 -0500, you wrote:

>By the way, a couple more data points; the mysql root user does not have 
>a password.  Also, the mythfrontend password is still mythtv, not the 
>generated one (y2i1MpJ8).  When migrating the old database to the new 
>machine, it seems to use the stock 'mythtv' password, so I left it as-is 
>(changed config.xml password).  Any other suggestions?
>
>Don

There is a big difference between

sudo mysql

and

mysql -u root -p

When mysql is run from root with no password, it has full permissions
for everything possible.  When it is run as user root with "-u root",
it only has permissions a specified in the grants for user "root".

When you migrate a database (or restore an old one), only the
mythconverg database tables are migrated or restored by
mythconverg_restore.pl.  Users and their grants are stored in the
"mysql" database tables, and are not touched, so you have to manually
set them up again.  They must match what you have in your config.xml
files in /etc/mythtv, /home/mythtv/.mythtv and /home/<frontend
user>/.mythtv.  When I move a database, I normally copy the old
config.xml files and re-create the old users and grants, but you can
choose to use the new config.xml settings too.  But you still need to
create the users and grants.