[mythtv-users] Several backends and passwords

[Klaus Becker]

Le lundi 14 mai 2018, 10:49:08 CEST Stephen Worthington a écrit :
> 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'@'%';


Ok, done

Klaus