468,133 Members | 1,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,133 developers. It's quick & easy.

Privileges for TEMPORARY TABLES on MySQL 3.23 ?

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
0 1870

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Didier ROS | last post: by
reply views Thread by Partap Davis | last post: by
reply views Thread by Peter Gorelczenko | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Peter Gorelczenko | last post: by
reply views Thread by Fred Johnson | last post: by
1 post views Thread by Stefan van Roosmalen | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.