Menu
Deployed a new version of our app on heroku and migrated over database from previous free jawsdb instance. However now every time user signs up gives
(Mysql2::Error: INSERT command denied to user <username for instance
what have i missed
mysql2...)I have not had to grant access or anything like that before, anyone come across this?
thanks Ben
607
Adding a JawsDB plan to your Heroku app gives access to a fully-functional MySQL database with no barriers or hoops to jump through. Connect to your instance the way you would to any other MySQL server. JawsDB can be attached to a Heroku application via the CLI:
Step 1 - Find Your MySQL Credentials in Heroku You want to go to your MySQL dashboard in Heroku and find your: Host Username Password Database Your Heroku Dashboard for MySQL can be found here. No, I don't know why it is called "jawsdb"; some kind of shark fetish perhaps … Step 2 - Dump Your Database Locally
Step 1 - Find Your MySQL Credentials in Heroku You want to go to your MySQL dashboard in Heroku and find your: Host Username Password Database Your Heroku Dashboard for MySQL can be found here. No, I don't know why it is called "jawsdb"; some kind of shark fetish perhaps …
Once JawsDB has been added, a JAWSDB_URL setting will be available in the app configuration and will contain the MySQL connection string. Your MySQL database will be created from scratch and will require a few minutes to become fully available. The JAWSDB_URL config variable will contain a placeholder until the database is ready.
My guess is they disabled your INSERT grant because you have reached your max Storage Capacity for your plan.
To validate this is a permissions problem, log into a MySQL prompt with the user the app is running as, and enter this query:
SHOW GRANTS;
It probably list many, but no INSERT.
128
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
