Hi,
I am creating a small web based program for users to access the data in the datbases. New databases will be added in later. I want to create a user to access these databases with certain rights, not all rights. Will I have to grant this user right to each database as I add them in or is there a way to give this user rights to all databases (EXCEPT for mysql DB) including DB's I'll add later. Other than the mysql database there is no database on this server that this user should be elcluded from. What is the best way to handle this?
Grant the user privileges for each database. There is no syntax for "all except".
Thanks, Michael
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
