I created a new user with a GRANT statement like: GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO 'demouser'@'localhost' IDENTIFIED BY 'testpwd' WITH GRANT OPTION
If I then log in as 'demouser' I can execute SELECT etc. statements on the 'test' database, but if I try to create another user with access to 'test' using: GRANT Select ON test.* TO 'newuser'@'localhost' IDENTIFIED BY 'newpwd' I get: Error: 1044 - Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' Does 'demouser' have to be explicitly GRANTed access to the MySQL grant tables (user, db, host, tables_priv and columns_priv) before the user can be GRANTed GRANT privileges to any database or table? If so, what are the minimum privileges required? John R. Porter I.T. Services University of Strathclyde Faculty of Education 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
