[mythtv-users] Several backends and passwords

[Stephen Worthington]

On Mon, 14 May 2018 10:19:14 +0200, you wrote:

>> You can change the password of a user in the database:
>> 
>> https://mariadb.com/kb/en/library/set-password
>> 
>> From root if you run "mysql" then these commands, you will see the
>> list of users:
>> 
>> use mysql;
>> select user,host from user;
>> 
>> This is what I get:
>> 
>> MariaDB [mysql]> select user,host from user;
>> +--------+---------------------+
>> 
>> | user   | host                |
>> 
>> +--------+---------------------+
>> 
>> | mythtv | %                   |
>> | root   | localhost           |
>> | root   | savaidhg.jsw.gen.nz |
>> 
>> +--------+---------------------+
>> 3 rows in set (0.00 sec)
>> 
>> So I have three users:
>> 
>> 'mythtv'@'%'
>> 'root'@'localhost'
>> 'root'@'savaidhg.jsw.gen.nz'
>
>
>I get:
>
>MariaDB [mysql]> select user,host from user;
>+------------+-----------+
>| user       | host      |
>+------------+-----------+
>| klaus      | %         |
>| mythtv     | %         |
>| stephen    | %         |
>| mythtv     | localhost |
>| phpmyadmin | localhost |
>| root       | localhost |
>+------------+-----------+
>6 rows in set (0.00 sec)
>
>I suppose I should delete some users. Wich ones and how ?

The only one that likely needs deleting there is me.  The others all
look as though they are needed or useful.

The DROP USER command is documented here:

https://mariadb.com/kb/en/library/drop-user/

So to delete me, you would do:

drop user 'stephen'@'%';


>> To change the password for the mythtv user to 'new password', the
>> command would be:
>> 
>> set password for 'mythtv'@'%' = PASSWORD('new password');
>
>Works, thank you
>
>Klaus