Hi, Rhys, Felipe,

It's not reserved in any way.

If you create a user named "system user", you'll see yet another "system user" row in the SHOW PROCESSLIST, but with non-empty host. That's all.

On Feb 15, 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 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!

Regards, Sergei Chief Architect MariaDB and security@mariadb.org

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

Travis Runyard travisrunyard@gmail.com

On Fri, Feb 15, 2019 at 2:49 AM Travis Runyard travisrunyard@gmail.com 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@gmail.com

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