Re: # of connected user

2003-02-02 Thread Stefan Hinz, iConnect \(Berlin\)
Mustafa, > How i list connected users(active) to mysql server? mysql> SHOW PROCESSLIST; ++---+---+--+-+---+ | Id | User | Host | db | Command | Time | ++---+---+--+-+---+ | 2 | superuser | localhost | test | Sle

Re: # of connected user

2003-02-01 Thread Giorgos Gaganis
try using the command: mysqladmin -v processlist Gaganis Mustafa Yelmer wrote: How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of clients are different (i assume) Mustafa Yelmer Software Eng

RE: # of connected user

2003-02-01 Thread Lopez David E-r9374c
Mustafa Try this command from the client window: show processlist; You must be logged in from root to list all connections. If you are logged in as normal user, only those connections which you have privileges are listed. David > > How i list connected users(active) to mysql server? > --

Re: # of connected user

2003-02-01 Thread Zak Greant
On Fri, Jan 31, 2003 at 01:49:24PM +0200, Mustafa Yelmer wrote: > How i list connected users(active) to mysql server? > > it is important to know connected users for me? > Mysql runs in server-client system, and each host of clients are different > (i assume) Good Day Mustafa! You can get a li

Re: # of connected user

2003-02-01 Thread Diana Soares
Don't know if i understood your question very well, but try: # mysqladmin proc in command line or execute the query SHOW PROCESSLIST On Fri, 2003-01-31 at 11:49, Mustafa Yelmer wrote: > How i list connected users(active) to mysql server? > > it is important to know connected users for me? > Mysq

Re: # of connected user

2003-02-01 Thread Joseph Bueno
SHOW PROCESSLIST Check http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html for details Hope this helps, Joseph Bueno Mustafa Yelmer wrote: How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of clie