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. Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/237835-question-about-mysql-connections/#findComment-1222200 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.