maria-discuss team mailing list archive

[Travis Runyard <travisrunyard@xxxxxxxxx>]

Discard what I wrote, I would take Sergei's word over mine.

Travis Runyard
travisrunyard@xxxxxxxxx


On Fri, Feb 15, 2019 at 2:49 AM Travis Runyard <travisrunyard@xxxxxxxxx>
wrote:

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