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