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

[Stephen Worthington]

On Tue, 2 Nov 2021 05:10:38 -0400, you wrote:

>
>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

Right, so you would need to do a "DROP USER 'mythtv'@'%';" command.
That also deletes all the GRANTs for that user.