mysql is in read-only mode. can't alter procedures. How do I enable that write
The owner of the procedure or admin will have to grant alter to the procedure.
Hope that helps,
I get what you are saying now. In the past, we have not supported MySQL Alter Procedure because MySQL does not support Atomic DDL for altering procedures. An atomic DDL requires a ALTER PROCEDURE DDL or DDL in transactions, and MySQL doesn't support either. I have opened Aquacluster issue 15846 to revisit this feature and see if we can now improve it.
Powered by IDERA