Professional Web Applications Themes

how to see users logged into mysql? - MySQL

hi! how to see users logged into mysql? I would like to know who is actually logge into MySQL under my slack greetings jerzu...

Sponsored Links
  1. #1

    Default how to see users logged into mysql?

    hi!
    how to see users logged into mysql?
    I would like to know who is actually logge into MySQL under my slack

    greetings
    jerzu
    Sponsored Links
    nousernospam Guest

  2. #2

    Default Re: how to see users logged into mysql?

    Hi,

    If you have the SUPER privilege, you can do this with 'show processlist'
    (without the SUPER privilege, you will only see your connections).

    Markus


    "nousernospam" <nousernospamwp.pl> schrieb im Newsbeitrag
    news:gxle5x1tqsfx.10h8gaj5kycib.dlg40tude.net...
    > hi!
    > how to see users logged into mysql?
    > I would like to know who is actually logge into MySQL under my slack
    >
    > greetings
    > jerzu

    Markus Popp Guest

  3. #3

    Default Re: how to see users logged into mysql?

    Dnia Tue, 13 Dec 2005 15:32:24 +0100, Markus Popp napisał(a):
    > Hi,
    >
    > If you have the SUPER privilege, you can do this with 'show processlist'
    > (without the SUPER privilege, you will only see your connections).
    I am root but I cant see all users in process list - I see only mine
    processes :(
    nousernospam Guest

  4. #4

    Default Re: how to see users logged into mysql?

    nousernospam wrote:
    > Dnia Tue, 13 Dec 2005 15:32:24 +0100, Markus Popp napisał(a):
    >
    >> Hi,
    >>
    >> If you have the SUPER privilege, you can do this with 'show processlist'
    >> (without the SUPER privilege, you will only see your connections).
    > I am root but I cant see all users in process list - I see only mine
    > processes :(

    In which case there are no users 'logged in'. If a user has a
    connection and isn't doing anything it will still show up in the
    processlist in the 'sleep' state.



    --
    Brian Wakem
    Email: [url]http://homepage.ntlworld.com/b.wakem/myemail.png[/url]
    Brian Wakem Guest

  5. #5

    Default Re: how to see users logged into mysql?

    "nousernospam" <nousernospamwp.pl> wrote in message
    news:15uo9g3gqezl0.12qv3p6ntduat$.dlg40tude.net.. .
    > I am root but I cant see all users in process list - I see only mine
    > processes :(
    Start a session in the "mysql" tool using another MySQL account in another
    window. Then do show processlist again in your root MySQL session. Do you
    see the additional account?

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. MSI file installation fails on computers with logged-inrestricted users
    By Nate Allen in forum Macromedia Flash Player
    Replies: 24
    Last Post: May 24th, 08:00 PM
  2. Hard to explain, has to do with users, last logged intime, and my database
    By kenji776 in forum Coldfusion - Advanced Techniques
    Replies: 16
    Last Post: July 29th, 03:30 AM
  3. MySQL and 80,000+ users
    By Mohamed Hosam in forum ASP Database
    Replies: 13
    Last Post: December 15th, 03:38 PM
  4. Logged users showing as "ADMIN"
    By Dan Artuso in forum Microsoft Access
    Replies: 3
    Last Post: July 18th, 08:35 PM
  5. asp get Table Column ( Show Active Users Names Logged On )
    By Wayne & Carr in forum ASP Database
    Replies: 8
    Last Post: July 18th, 05:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139