Web lists-archives.com

Re: When to create a new user?

Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
okay to execute their queries with the same (one generic) MySQL username
and password?

one generic for the application

since you normally never ever should connect as root to your application it even don't have the permissions to add mysql-users

how would you even imagine working with a usertable on your applications side which is for every user different - chicken/egg

Attachment: signature.asc
Description: OpenPGP digital signature