Ok. Someone else was talking about this earlier in the list, but I didn't
see the answer that I am looking for. I have just setup a new RedHat 9.0
server with MySQL 3.23.58. My program that worked on an older version of
MySQL doesn't work on this one. The problem is that the temporary
, or can be manipulated using something like the following,
which is a little easier to try out:
GRANT
CREATE TEMPORARY TABLES
ON my_db.* TO 'user' IDENTIFIED BY 'pass';
I'm doing this and it works fine :) I guess if you have multiple databases
and users you could make a INSERT INTO ... SELECT