After inadvertantly emailing some db access credentials to myself, I realized I need to set up my test boxes with better user perms.
Recommended user permissions:
GRANT PROCESS, SUPER ON *.* TO 'ajaxmytop'@'localhost' IDENTIFIED BY 'ajaxmytop';
GRANT PROCESS, SUPER ON *.* to 'ajaxmytop'@'%' IDENTIFIED BY 'ajaxmytop';
This will give the ajaxmytop user the ability to see the processlist and the ability to kill threads.
then change the user/pass to whatever user/pass to which you granted the PROCESS & SUPER permissions.
Log in to post a comment.