Password in MySQL or PHP

[paulsim]

Which is best?

One can store passwords for users in PHP and have a sort of generic user for MySQL to connect to MySQL.

or one can have many users in MySQL, each with their own password stored by MySQL.

I have a database program with 100 users.

I want the users to be able to change their own passwords.

Which is the best bet - any strong thoughts?

Paul

[Anon]

you can modify users own password to connect to MySQL by modify data in 'user' table in 'mysql' db.

if you wanna the users to be able to change their onw passwords to connect to MySQL, make a new-account to access 'mysql' db. and coding sql query to modify their user account info.

Laziel