search

dokku / dokku-mysql

a mysql plugin for dokku
MIT License
97 stars 39 forks source link

Unable to import mysqldmp ( permissions issue) #88

Closed dpanyam closed 6 years ago

dpanyam commented 6 years ago

I have created a myql service and linked it to my app. I have a MYSQLDUMP file from where i would like to import. The default user "mysql" created as part of setting up the mysql service has no permissions although it is the root user.

I chatted with Savant and he asked me to file this issue. Appreciate if this can be fixed ASAP because we are ready to move to production

root@ip-172-31-0-23:/home/ubuntu# dokku mysql:import main < dump.sql ERROR 1227 (42000) at line 958: Access denied; you need (at least one of) the SUPER privilege(s) for this operation root@ip-172-31-0-23:/home/ubuntu#

dpanyam commented 6 years ago

Import failing with the default mysql user created while setting up the mysql service need to use root user and ROOTPASSWORD submitted a PR

josegonzalez commented 6 years ago

Closing as there is a pull request open.