doadmin does not have enough privileges to import mysql and cannot alter

Posted January 14, 2022 89 views
DigitalOcean Managed MySQL Database

I am experimenting with setting up a Mysql DB server in DO for the first time trying to import Data from RDS (MySQL 5.7). However, my import is failing because I dont have enough privileges for the doadmin user…

Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation

Which puts me in a rather endless loop as I cant modify that user, its the highest privileges I can get?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi there,

What you could do is to edit the .sql export and comment out the line that is throwing the error.

In most cases, such lines are vendor-specific configurations and do not affect your data.

Let me know how it goes.

  • As a side note, I have migrated thousands of databases in my previous job and I’ve seen this quite a lot with various different providers so I’m fairly certain that this should work in your case too.

    Another option is, if you are using the mysql command-line tool to specify the -f parameter which stands for force, and would not stop the import in case such error occurs so it will complete the import anyway.

  • Ok thanks, that worked on a single table I tried, are there access to some of the SQL_MODE flags for tweaking import behaviour etc? doadmin does not have permissions.
    And there are some mysql5.7 compatibility issues as well.