I have (2) accounts in my database root and dba.
I created the dba account.
I run the following against each user.
select * from information_schema.processlist
Root shows all processes. dba only shows User dba processes.
I tried assigning all privileges to dba. then restarting the server. However this had no effect.
How do I get a full process list using the dba account?
I am new to this forum and this is my first post.