mysql is in read-only mode. can’t alter procedures. How do I enable that write
Response
Thomas Conrad over 2 years ago
Hello,
The owner of the procedure or admin will have to grant alter to the procedure.
Hope that helps,
Tom
Thomas Conrad over 2 years ago in reply to Thomas Conrad
Hi Evan,
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.
Thanks,
Tom
Evan over 2 years ago
I have the same problem. I can alter procedure with the same user on the same server in another IDE (HeidiSQL). In Aqua Data Studio 21.1 (Standard) only “this view is read only”. Already tried to reinstall Studio or reregister server.
And I can alter procedure in same client of Aqua Data Studio in another DB (Informix)…