How to display the queries executed by a particular user in MySQL?

0 votes
Mar 6 in Database by Mugdha
• 580 points
32 views

1 answer to this question.

0 votes
From the version 5.1.7 onward, MySQL allows to use the PROCESSLIST table of the INFORMATION_SCHEMA. So a query similar to this can be used:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER='<name_of_the_user>';

Hope this helps,

Happy Learning!
answered Mar 7 by Mishti
• 480 points

Related Questions In Database

0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
188 views
0 votes
1 answer

What are the steps performed by Migration Wizard while migrating a database to MySQL?

The following are the steps  performed by ...READ MORE

answered Dec 10, 2018 in Database by darklord
• 6,140 points
85 views
0 votes
1 answer

What are the ways to get the count of records in a table

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,140 points
58 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,810 points
181 views
0 votes
1 answer

What is the ORDER BY statement in MySQL?

This statement is used to sort the ...READ MORE

answered Nov 23, 2018 in Database by darklord
• 6,140 points
25 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4 in Database by Priyaj
• 56,520 points
69 views
0 votes
1 answer

What is MySQL Workbench?

MySQL Workbench is a designing or a ...READ MORE

answered Nov 29, 2018 in Database by darklord
• 6,140 points
18 views
0 votes
1 answer

MySQL Workbench Functionalities

The functionalities of MySQL Workbench are as ...READ MORE

answered Nov 29, 2018 in Database by darklord
• 6,140 points
35 views
0 votes
1 answer

What are the various MySQL Workbench editions?

MySQL Workbench is mainly available in three ...READ MORE

answered Dec 6, 2018 in Database by CodingByHeart77
• 3,680 points
43 views
0 votes
1 answer