Mysql Issue

[coleary]

Hrm, not sure why this isn't working... but I'm trying to do the following query...

 

>SELECT a.*, b.* 
       FROM a.Loot_Tables, 
         b.Phase_Gods
      	 WHERE a.god_id = b.god_id 
      	 AND a.has_stats = 0 ORDER BY b.phase ASC

 

... and I keep getting the following error....

 

>MySQL said: 

select command denied to user: 'triton-@localhost' for table 'Loot_Tables'

 

I've tried multiple users, all which have been assigned to the table, and I keep getting this error. Are sub-selects disabled?

[coleary]

Anyone have any ideas? It's very frustrating to need table linking and lacking the ability to do it. Keep in mind I have done it in the past.

[TCH-Rick]

Make sure that you have set up the database in Manage MySQL in your CPanel and added users there. In looking at the database on the server it is empty. IM me and I can get more information.