[mythtv-users] Mythfrontend on Android-database access

[Mike Perkins]

On 16/05/2022 03:14, Stephen Worthington wrote:
> 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.
> 
Can I ask why the old users and grants are not migrated along with the database? After all, these 
are essential metadata and having to (research and) re-input those commands introduces possibilities 
for mistakes and errors.

-- 

Mike Perkins