Re: query list of connected users to MySQL DB?
mitchell.ad@xxxxxxx wrote:
Does anyone know how to query the database within a java to display a
list of users who have connections to the database?
Try executing the query "SHOW PROCESSLIST", as you would using the MySQL
command-line client. You will get a ResultSet which contains the same
information as you see in the command-line client.
Caveat: you need to execute this command as a user with the PROCESS
privilege in order to see all of the other users who are connected to
the database. Otherwise, you see only those server threads that belong
to the same user as the one making the query.
David Harper
Cambridge, England
.
Relevant Pages
- Re: user permissions
... A user should be able to kill connections only for a specific database. ... stored procedure, by doing an EXECUTE AS LOGIN and then kill any connection. ...
(microsoft.public.sqlserver.security) - Re: How can I open an SQL database and be the only one who has access to it?
... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
(microsoft.public.data.ado) - Re: ORA-12518, 04030 errors after 9i-10G upgrade.
... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors. ...
(comp.databases.oracle.server) - Re: ORA-12518, 04030 errors after 9i-10G upgrade.
... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors. ... that Oracle is having issues with OS resources. ...
(comp.databases.oracle.server) - Re: ORA-12518, 04030 errors after 9i-10G upgrade.
... New server has 6GB ram. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ...
(comp.databases.oracle.server) |
|
