maria-discuss team mailing list archive

[Travis Runyard <travisrunyard@xxxxxxxxx>]

I'm pretty sure, or at least I thought that MariaDB/MySQL both used the
same scheme of identifying system users as differentiated from regular
users via another attribute besides the name string itself. In MSSQL if you
execute:

USE Master
> select * from sys.dm_exec_sessions


All users with a session_id ≤ 50 is a system login.

Travis Runyard
travisrunyard@xxxxxxxxx


On Fri, Feb 15, 2019 at 12:11 AM <Rhys.Campbell@xxxxxxxxxxxx> wrote:

> The "system user" identifies internal tasks spawned by the server. See
> here...
>
> https://stackoverflow.com/questions/10330159/mysql-system-user
>
> Never tried to create a user called this so no idea if it's reserved...
> but not really a good idea anyway.
>
> Rhys
>
> -----Original Message-----
> From: Maria-discuss <maria-discuss-bounces+rhys.campbell=
> swisscom.com@xxxxxxxxxxxxxxxxxxx> On Behalf Of Felipe Gasper
> Sent: 14 February 2019 16:47
> To: maria-discuss@xxxxxxxxxxxxxxxxxxx
> Subject: [Maria-discuss] “system user” in SHOW PROCESSLIST
>
> Hi all,
>
>         https://mariadb.com/kb/en/library/show-processlist/
>
>         ^^ The above doesn’t describe “system user” in the result of SHOW
> PROCESSLIST, but that’s what I observe in 10.2.21.
>
>         What is the meaning of “system user” in the output of this
> command? Is there a list of these “special” values for the User column? Are
> these reserved names (i.e., no DB user should be named “system user”)?
>
>         Thank you!
>
> -FG
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>