db user/access suggestion

  • groovecoder

    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.