Create_tmp_table_priv - how to grant? - solved

2004-03-24 Thread Hugh Beaumont
Hi List, Ok, I'm a moron... problem solved: Should have been: grant CREATE TEMPORARY TABLES ... and not grant Create_tmp_table_priv ... Well atleast this is now in the archives for search engines to pick up on... I swear I sat there for 10 minutes thinking "Should I clutter the list wit

Create_tmp_table_priv - how to grant?

2004-03-24 Thread Hugh Beaumont
Hi List, I hate to bother the list with what should be a simple question but I've been unable to get this to work or find anything on mysql.com or google. I need to grant : Create_tmp_table_priv on a particular database. As root (mysql user) I tried : grant Create_tmp_table_priv on mydatabas