> -----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]

Reply via email to