Submitted by pricetapid on Fri, 2010-04-02 13:29 in Price Tapestry
Hi,
I installed PT successfully and I was wondering, what would be the suggested minimum privileges for the MySQL user to running PT properly. Right now, the user has all privileges, even stored procedures.
After running setup.php, the database user being used by Price Tapestry would only require SELECT, INSERT, UPDATE and DELETE. Initially, CREATE would be required, but that could be removed after running setup.php if desired.
However, certain mods that you will find documented throughout the forum involve adding new indexes, as well the import into temporary table mod that uses CREATE, so bear that in mind if making changes that would require more than the basic 4 privileges...
Hi,
After running setup.php, the database user being used by Price Tapestry would only require SELECT, INSERT, UPDATE and DELETE. Initially, CREATE would be required, but that could be removed after running setup.php if desired.
However, certain mods that you will find documented throughout the forum involve adding new indexes, as well the import into temporary table mod that uses CREATE, so bear that in mind if making changes that would require more than the basic 4 privileges...
Hope this helps!
Cheers,
David.