Search code examples
mysqlherokumysql-workbench

Pushing data to cleardb Heroku via mysql workbench throwing error

ERROR 1044 (42000) at line 1: Access denied for user 'user_name_of_cleardb_at_heroku'@'%' to database 'i_am_uploading'

I dumped data from my localhost to a dump folder via mysql workbench. I'm uploading the same dump filer data to heroku. I'm getting this error. I made the server instance successfully ?

What exactly is the problem ? How can I debug ?

Solution

  • The error message says it clearly. The user user_name_of_cleardb_at_heroku does not have the rights to act on the db 'i_am_uploading'. So first grant rights to that user and then try again. Alternatively use a user with the proper rights. See http://dev.mysql.com/doc/refman/5.6/en/grant.html for the syntax of GRANT. You probably need something like:

    grant all on i_am_uploading.* to user_name_of_cleardb_at_heroku@%;

    You need to run this with a user who has rights to grant privileges.