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