groovecoder - 2006-01-19

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.