By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,856 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,856 IT Pros & Developers. It's quick & easy.

Privileges for TEMPORARY TABLES on MySQL 3.23 ?

P: n/a
Dear Sirs,

I have been developing an application on Windows with MySQL 3.23,
making use of temporary tables.

Now when I try to port the application to a Unix box running
also MySQL 3.23, I keep running into "access denied" errors with
the queries which employ temporary tables. This only happens
with CREATE TEMPORARY TABLE type queries, all other queries work
fine.

I have given my user all privileges (CREATE, ALTER, INDEX, DELETE)
to the database yet still it can not create temporary tables.
Is there a special command for allowing temporary tables on MySQL 3.x ?

Thank you very much,

Soefara Redzuan
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.