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.On Fri, Feb 15, 2019 at 12:11 AM <Rhys.Campbell@swisscom.com> 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@lists.launchpad.net> On Behalf Of Felipe Gasper
Sent: 14 February 2019 16:47
To: maria-discuss@lists.launchpad.net
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp