> -----Original Message----- > From: Fernando Melo [mailto:[EMAIL PROTECTED]
> Inside my program (PHP) I want to provide a field where the user > can select > a database. Since I don't want clients accessing into other clients' > databases, I need to do user-level access control within MySQL whereby a > user will only have read/write access to his/her database based on their > login/password. > > Is this possible and can it be automated? Yes. You can use the GRANT command to allocate user rights. See: http://www.mysql.com/doc/en/User_Account_Management.html - Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]