imperium2335 Posted January 19, 2012 Share Posted January 19, 2012 Hi, I have wondered if just one user should be used (e.g. root) for connecting to the database is the right way of doing things? (which is what I have always done). Would it be better to have a new user created in the privileges section in MySQL and have all operation/table access assigned appropriately for every single user that signs up? I would think that this would give a lot more security but would need a bit more work. What are your thoughts? Quote Link to comment https://forums.phpfreaks.com/topic/255351-mysql-privileges-per-user-signup/ Share on other sites More sharing options...
dzelenika Posted January 19, 2012 Share Posted January 19, 2012 It's unnecessary complication and resource wasting on web apps. Imagine how many db users shuld be created for this forum. Quote Link to comment https://forums.phpfreaks.com/topic/255351-mysql-privileges-per-user-signup/#findComment-1309188 Share on other sites More sharing options...
PFMaBiSmAd Posted January 19, 2012 Share Posted January 19, 2012 The root user should only be used for administrative purposes. You should already have a general purpose database user/password that only has SELECT, INSERT, UPDATE, and perhaps DELETE privileges that you use in actual applications. Quote Link to comment https://forums.phpfreaks.com/topic/255351-mysql-privileges-per-user-signup/#findComment-1309189 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.