Zymic Forums

Webmaster resources

Zymic IRC Server

Chat in real time at irc.zymic.com - Learn More

Welcome

Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.

In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.

left Zymic Webmaster ForumsZymic Free Web HostingDatabases & MySQL right
  Reply to this topic Start new topic
left right
daniz
post Apr 26 2012, 12:03 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 25-April 12
Member No.: 239,456



Hi all,
I granted all possible priviledges to my DB using Zymic DB Management console.
But, looks like I have no permission for TEMPORARY TABLE creation in my DB.
All other tables are created successfully.
The TEMPORARY TABLE creation results in Error 1044 : Access Denied.
The SQL syntax is correct because it works on my other hosting.
So, the question: How can I enable creation of TEMPORARY TABLES in my DB?

Best Regards,
Daniel
Go to the top of the page 
 
  + Quote Post
rhannebaum
post May 31 2012, 06:30 PM
Post #2


Newbie
*

Group: Members
Posts: 1
Joined: 31-May 12
Member No.: 244,036



I am having this issue as well. I have CREATE privileges, and can CREATE TABLE just fine; but I cannot CREATE TEMPORARY TABLE.

Please assist. Thanks.
Go to the top of the page 
 
  + Quote Post
 Reply to this topic Start new topic
left right
0 Members:
left right
 


Lo-Fi Version Time is now: 19th May 2013 - 02:37 AM