Discard what I wrote, I would take Sergei's word over mine. Travis Runyard [email protected]
On Fri, Feb 15, 2019 at 2:49 AM Travis Runyard <[email protected]> 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 > [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
