Creating Temporary Table Problems

[southcot]

I am using SQLyog Enterprise 5.11 and MySQL 4.0.24_Debian-10ubuntu2.1.

I have set up a user for a specific data base and have given the user all of the following local permissions to the database:-

Select, Insert, Update, Delete, Create, Drop, Grant, References, Index and Alter.

In addition to this the user has the following Global Permissions:-

Reload, Create and File.

When we try and create temporary tables using this account we get the error:-

CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;

results in:

Error Code : 1044

Access denied for user: 'username@%' to database 'dbname'

Can anyone advise me on how I resolve this?

Thanks

[peterlaursen]

User will need CREATE_TMP_TABLE privilege. This privilege was introduced with MySQL 4.02. SQLyog 5.2 (in beta) can handle ALL privileges for every MySQL version (including 5.1).

[southcot]

Many thanks this was just the ticket.

[Author]

Posts