eMonk Posted May 30, 2011 Share Posted May 30, 2011 Should I be using a different mysql connection for users visiting the page. For example, just give them SELECT access? Right now I'm just using 1 connection which is the admin user with all grants. I haven't made a members area yet but when I do new member accounts will only be grated with SELECT and UPDATE. I don't recall having to config 2 connection types when installing php/mysql scripts in the past but just want to make sure. Link to comment https://forums.phpfreaks.com/topic/237835-question-about-mysql-connections/ Share on other sites More sharing options...
requinix Posted May 30, 2011 Share Posted May 30, 2011 You don't need to give each user a personalized MySQL user. It's more wasteful than anything. Basically everything you should ever need to do is a SELECT, INSERT, UPDATE, or DELETE. Restrict the account to just those. Link to comment https://forums.phpfreaks.com/topic/237835-question-about-mysql-connections/#findComment-1222193 Share on other sites More sharing options...
eMonk Posted May 30, 2011 Author Share Posted May 30, 2011 Ok, thanks for confirming requinix. Link to comment https://forums.phpfreaks.com/topic/237835-question-about-mysql-connections/#findComment-1222200 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.