php mysql database users connection handling

Posted by aviv on Stack Overflow See other posts from Stack Overflow or by aviv
Published on 2010-03-14T17:05:05Z Indexed on 2010/03/14 17:15 UTC
Read the original article Hit count: 251

Filed under:
|
|
|
|

What is the best way to handle mysql database users connection in PHP?

I have a web server running a PHP application on MySQL. I have created a database user for the application: dbuser1 with limited access - only for query, insert and update tables. No alter table.

Now the question is, should i use the same dbuser1 widely in my scripts, so if there are 100 current people using my system and hence 100 scripts running parallel they all connect to the database with the same dbuser1? or should i create a few users and assign each script a different user or load-balance between the dbusers ?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about users