Mulitple users (scripts) same login? Is this a problem
Posted: Fri Mar 02, 2007 4:55 am
Hi
Hope someone can help.
I have numerous PHP scripts that all access the same database, so I used the same username and password each time a connection was needed.
Now I have started to run some processes via cron and there is a recurring situation where more that 1 script will run at the same time and try to access the database.
My question is, would this be a problem, i.e would one script kick another one out if they are both using the same log in at the same time to access the same database. Should I be providing each script with its own user name, password and access rights?
The reason I ask is that I've started noticing some funny behaviour since this situation arose and I wondered if this was the cause.
Thanks in advance for any replies
Hope someone can help.
I have numerous PHP scripts that all access the same database, so I used the same username and password each time a connection was needed.
Now I have started to run some processes via cron and there is a recurring situation where more that 1 script will run at the same time and try to access the database.
My question is, would this be a problem, i.e would one script kick another one out if they are both using the same log in at the same time to access the same database. Should I be providing each script with its own user name, password and access rights?
The reason I ask is that I've started noticing some funny behaviour since this situation arose and I wondered if this was the cause.
Thanks in advance for any replies