471,064 Members | 1,727 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,064 software developers and data experts.

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 1955

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.