# Heroku Deployment Experience and MySQL INSERT Permission Issue

DevFeed: [Heroku Deployment Experience and MySQL INSERT Permission Issue](<https://devfeed.tech/articles/heroku-is-amazing-or-fixing-insert-command-denied-to-user-mysql-28177.md>)

Original publisher: [Read original article](<http://fuzzyblog.io/blog/heroku/2019/10/25/heroku-is-amazing.html>)

Author: Fuzzygroup

Published: 2019-10-25T00:00:00Z

Content type: opinion

Language: en

Sources: [Scott Johnson](<https://devfeed.tech/sources/scott-johnson.md>)

Topics: [Heroku](<https://devfeed.tech/topics/heroku.md>), [Deployment](<https://devfeed.tech/topics/deployment.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [deploy](<https://devfeed.tech/tags/deploy.md>), [heroku](<https://devfeed.tech/tags/heroku.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [rails](<https://devfeed.tech/tags/rails.md>)

## AI overview

The author describes positive experiences deploying Rails applications to Heroku, then investigates a MySQL INSERT permission error. The article says upgrading the Heroku MySQL add-on from its 5 MB baseline plan to a 1 GB plan restored the permission.

## Source excerpt

Photo courtesy of my boss and friend, Dave Sifry who is in London right now attending MozFest; lucky guy! Part 1: Heroku Rocks I've been using Heroku quite a lot recently: It is currently running my side project I built a trial project purely to confirm that I knew how to deploy onto Heroku and then deployed it in just an hour or two I deployed a proof of concept app for my day gig onto it that's pretty substantial Overall I've never had such a seamless deploy experience using Rails as I've had with Heroku. And I when I say seamless, I mean "you can build a Rails app and deploy it in just a few hours". Twelve plus years of Rails and I've never had such an easy time deploying things. I was very, very skeptical of the Heroku git push style deployment for a long, long time and I have to admit: I was wrong! Amazingly wrong! I have always come at deployment from a traditional, heavy weight model. And to have deployment not really be an issue is just shocking. This isn't to say that Heroku is perfect, it isn't - but it is damn amazing. Recommended. Part 2: This is How Cloud Computing Was Supposed to Work Now, with the laudatory statements aside, I did hit an interesting bug / issue in Heroku today. I use Heroku with MySQL because, well, I've put terabytes of data into MySQL over the years and it has never let me down. Today tho I got this weirdness: mysql -ua_user_name -pa_passowrd a_database --host=a.rds.host.amazon.com < lib/tasks/data/db_dumps/police_crawl_development_2019-10-25.sql ERROR 1142 (42000) at line 40: INSERT command denied to user 'cbneustt0on66p30'@'208-70-45-211.bb.hrtc.net' for table 'ar_internal_metadata' My first thought was that the database instance wasn't fully logically isolated from others and I used -ignore-table to not export ar_internal_metadata. And, clearly, that was a stupid idea because it just failed on the next table. I did some digging and ended up on an obscure Stack Overflow page which said something to the effect that "Heroku limits y