[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
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
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
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
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
participants (4)
-
Felipe Gasper -
Rhys.Campbell＠swisscom.com -
Sergei Golubchik -
Travis Runyard