Error: 1142 INSERT command denied to user
The user I am using is the same for both databases, yet I am getting this denied error message. I can do a simple insert into each database, I just can't insert into one from the other. Here is my insert query:
WHERE wantSilver = 'Yes';
What am I missing here?