Question

Alan.Qualimedia on Thu, 06 Jul 2017 13:53:10


I would like to know how do I create procedures and views in the azure mysql database. Because when trying to create with my user admin, it returns me an error saying that I do not have superuser privileges.

Sponsored



Replies

Lin Leng on Fri, 07 Jul 2017 09:07:52


Hi Alan,

>>Because when trying to create with my user admin, it returns me an error saying that I do not have superuser privileges.

Could you please check your CREATE VIEW scripts see if you have and DEFINER in your statement? If it does, MySQL needs SUPER privilege to execute the statements, which would cause failure in Azure database for MySQL. In this case, remove all DEFINER from your script should workaround the limitation.

If you have any other questions, please let me know.

Regards,
Lin