Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Creating Temporary Table Problems
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).
Many thanks this was just the ticket.