bri0987 Posted November 29, 2007 Share Posted November 29, 2007 For the MySQL database associated with my PHP shopping cart... What is the Privileges I should set for the database user that my admin and customers use with the database? >>> Currently the user has these privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE (FYI: I use PhpMyAdmin) Thanks BRI Quote Link to comment Share on other sites More sharing options...
revraz Posted November 29, 2007 Share Posted November 29, 2007 Your users dont directly interact with the database, your PHP scripts do. Quote Link to comment Share on other sites More sharing options...
bri0987 Posted November 29, 2007 Author Share Posted November 29, 2007 I was not sure if I made the wrong chooses, that a hacker could could in and RUN "DELETE TABLE" scripts or something like that... what do ya think? or should I not worry about it? Quote Link to comment Share on other sites More sharing options...
trq Posted November 29, 2007 Share Posted November 29, 2007 Generally speaking, the account with wich your php scripts connect to MySql via need only have access to SELECT, INSERT, UPDATE, DELETE. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.