Cloud sql mysql event cannot be deleted

[徐弘宇]

Cloud sql has event_scheduler enabled.

I added a new one to the mysql event, but I can't delete it.

Deny access; you need (at least one) SUPER permission for this operation.

How can I delete this incident?

[Aref Amiri (Cloud Platform Support)]

You are able to enable the flag on your instance, however, there are some restrictions or unsupported feature on some activity that only Super Users (backend) have access to and therefore you might get the same error you are encountering now.

In addition, what might have happened here, is that the privileges of root was revoked and to grant root privileges, could you try to run the command below in your Cloud SQL instance and try again:

- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

Please note that Google Groups is reserved for general product discussions and is not for technical support. If the issue persists, I would suggest to post a detailed description of the issue and post it on Stackoverflow, as experienced programmers are within reach and ready to help.

[徐弘宇]

徐弘宇於2019年5月28日星期二UTC + 8下午9時17分51秒寫道：

Cloud sql啟用了event_scheduler。

我在mysql事件中添加了一個新的，但我無法刪除它。

拒絕訪問; 您需要（至少一個）SUPER權限才能執行此操作。

我該如何刪除此事件？

Sorry, I made a stupid mistake.

I found a solution, I went to the mysql db event delete:

The correct process should not be removed in the default mysql db event.

Thank you for your assistance.