[mythtv-users] complete uninstall and reinstall on Ubuntu 20.04

[Jim Abernathy]

On 11/1/21 9:28 PM, Stephen Worthington wrote:
> On Mon, 1 Nov 2021 15:33:19 -0400, you wrote:
>
>> I know that when I install MythTV on an Ubuntu 20.04 machine it does
>> everything for me in regards to database, Mythweb, passwords and config
>> files.  However using apt remove --purge doesn't remove everything.
>>
>> What else do I need to delete to make the mythtv-setup start all over
>> again? I've tried removing the /etc/mythtv directory and the
>> /home/$USER/.mythtv directory.  I must be missing something.
>>
>> Maybe the mariadb database is still there???
>>
>> Jim A
> You also need to remove /var/lib/mythtv, as there are changed files
> there (database backups at least).
>
> I would think that there would be user data in the MySQL/MariaDB
> system tables also, even if the mythconverg database is purged.  To
> delete that you would need to know what users were created for use
> with mythconverg.  So do this:
>
> sudo mysql
> SELECT User, Db, Host from mysql.db where Db='mythconverg';

I just did this command on my production backend and I assume it would 
be the same on my test system.

mysql> SELECT User, Db, Host from mysql.db where Db='mythconverg';
+--------+-------------+------+
| User   | Db          | Host |
+--------+-------------+------+
| mythtv | mythconverg | %    |
+--------+-------------+------+
1 row in set (0.02 sec)

Jim A