Using MySQL non-root account

Discussion in 'Tips/Tricks/Mods' started by bolero, Jul 9, 2008.

  1. bolero

    bolero New Member

    You may not want to use the MySQL root account in ispconfig for security reasons. I didn't know that I have to use the root account and did it the same way as I always do with PHPMyAdmin. Worked fine until I started creating databases. I had to add a few more permissions to the ispconfig account. Here is a list of grants you need to apply, so that you can stop using the MySQL root account for ispconfig.

    Code:
    GRANT ALL ON ispconfig.* TO 'ispconfig'@'localhost' IDENTIFIED by 'yourpasswordhere';
    GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.db TO 'ispconfig'@'localhost';
    GRANT SELECT, INSERT, UPDATE, DELETE ON mysql.user TO 'ispconfig'@'localhost';
    GRANT RELOAD on *.* TO 'ispconfig'@'localhost';
    GRANT CREATE, DROP ON `web%`.* TO 'ispconfig'@'localhost';
    
    The last line depends on keeping the user naming scheme of "web....". If you use a different webid prefix adapt that line.
     
    Last edited: Jul 31, 2008

Share This Page