SUPER privilege needed for dump import

Question

SUPER privilege needed for dump import

Carlos Vidal 1

I'm trying to import a MySQL dump into a Azure Database for MySQL flexible server and I'm getting the fallowing error:

**ERROR 1227 (42000) at line 2081: Access denied; you need (at least one of) the SUPER privilege(s) for this operation**

It might be because the dump include some store procedures and views created by user admin, however the new DB was created with a different user.

Admin is not allow as a user name during DB deployment in Azure.

1 answer

Your answer

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi, @Carlos Vidal Welcome to the Microsoft Q&A Platform, and thanks for your query.
You would have to look at line 2081 as mentioned in the above error message to understand what command it is and how you can execute the same without Admin privileges. There are alternate ways in most situations. Or skip those if not required. But will depend on what is there in line 2081.

Also, in the limitations, super user privilege is not supported in Azure DB for MySQL. Please check the Unsupported section Here

The suggestions in this link might also help you.
Please let me know if the information is helpful

Regards
Geetha

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-24T14:31:41.507+00:00

Hi, @Carlos Vidal Just checking in to see if you had the chance to check the above reply.

Regards
Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-26T13:48:41.39+00:00

Hi, @Carlos Vidal Please let us know if you find the above reply useful. If yes, do click on the 'Mark as answer'
link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha
Carlos Vidal 1 Reputation point

2022-08-09T18:09:33.27+00:00

Hi Geetha

Sorry for not answering sooner.

Yes it help me understand the problem. However I still have not managed to import the database.

After replacing the username on several lines of my dump file and attempting to load it again I run into a different error.

I was think to open a different question for that.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-08-09T21:01:28.403+00:00

@Carlos Vidal Thanks for your response and understanding of the problem. please do raise a different query with us and we will help you to address it.

Thank you for visiting the Microsoft QA forums! Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Regards
Geetha

Share via

SUPER privilege needed for dump import

1 answer

Your answer