I’m frustrated

SELECT denied from Heroku

I'm trying to connect to my database from Heroku in Java.

I can create the database from my Heroku app successfully, however SELECT commands do not work.

I get:
SELECT command denied to user 'XYZ'@'ip-10-XX-XX-XXX.ec2.internal' for table 'foo'

I can use MySQL Workbench to connect and select from the same DB using the same credentials. Is there some magic Java incantation I'm missing? My DB create connection is from the exact same for both create and select.
1 person has
this question