Cannot change the mysql user privilages

Question

I am using Azure Database for MySQL flexible servers to manage my database. When I run the command below, I receive the result "Access Denied." I don't know how to access the admin account on Azure, but I can access the Azure portal. I have tried many times to get privileges for user_j, but I still cannot do it. Do you have any ideas?

[root@prod-hgc-app-1 ~]# sudo mysql -h mac-com.database.azure.com -u user_j -p studb < /home/app_user/language_lines_dump.sql Enter password: ERROR 1227 (42000) at line 24: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

Answer 1

Hi follow this thread https://learn.microsoft.com/en-us/answers/questions/1285957/how-to-configure-azure-my-sql-server-with-azure-ac

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

Regards,

Luis