how to fix this error

[ForceHSS]

for some time now I have been trying to fix this but have not found how. It use to work but for some reason now it wont

Database error in vBulletin 4.1.7:

Invalid SQL:
CREATE TEMPORARY TABLE cms_nc_orphans AS
select nc.nodeid FROM cms_nodecategory nc LEFT JOIN cms_node AS node on node.nodeid = nc.nodeid
WHERE node.nodeid IS NULL;;

MySQL Error : Access denied for user 'web247-james'@'%' to database 'web247-james'
Error Number : 1044
Request Date : Wednesday, November 30th 2011 @ 10:25:39 AM
Error Date : Wednesday, November 30th 2011 @ 10:25:40 AM
Script : http://www.my domain.net/cpanel/cms_content_admin.php?do=fix_nodes
Referrer : http://www.mydomain.net/cpanel/index.php?do=nav
IP Address : **.**.**.**
Username : Forcehss
Classname : vB_Database
MySQL Version : 5.1.56-community-log

[kh99]

I don't really know how to fix it, but I know that there is a separate permission for creating temporary tables, so maybe you need to be granted that permission.

[ForceHSS]

and where would that be found as I am set as super admin on my forums

[kh99]

It's a mySQL thing, and I really don't know much at all about doing mySQL admin.

[ForceHSS]

does any one know the correct query I have tried a few but no luck

[HMBeaty]

Do you have/use cPanel?

[ForceHSS]

this is what it is

[HMBeaty]

this is what it is
o.0 ......wtf is that? lol

Anyway, how do you get to your database? How do you add your users to the database(s)?

--------------- Added 1322720443 at 1322720443 ---------------

Problem solved (somewhat) via Skype

https://ssl.extendcp.co.uk/support.cgi?question=546

What are the default / allowed privileges for MySQL databases?

By default on all MySQL databases the current privileges are given -

SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES

CREATE TEMPORARY TABLES, CREATE VIEW, and CREATE ROUTINE privileges can be granted on request to Support.