Access Denied for CREATE TEMPORARY TABLE

[Robert Paulsen]

I must be missing something about "create temporary table". Here are two sql
commands. The first works the second fails:

  CREATE           TABLE mytable  (id int(10) NOT NULL auto_increment, data 
varchar(255), PRIMARY KEY (id) );
  CREATE TEMPORARY TABLE mytable2 (id int(10) NOT NULL auto_increment, data 
varchar(255), PRIMARY KEY (id) );

Prior to issuing the above commands I used the following grant command:

  GRANT ALL ON MYDB.* TO [EMAIL PROTECTED] identified by 'password'

I also tried the following:

  GRANT CREATE TEMPORARY TABLE ON MYDB.* TO [EMAIL PROTECTED] identified by 'password'

but it didn't help.

What am I missing?

-- 
Robert C. Paulsen, Jr.
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]