Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

i have a problem with my workbench program. I use Mac Lion OS X and mysql workbench program. When i want to do any procedure to alter that doesn't work. Which is show to the procedure code i right click it, after "Alter Procedure" click but doesn't happen anything!

i'm updated to MySQL Workbench program "5.2.45 revision 10251" to "5.2.47 revision 10398" but both are can not make alter procedure. And one odd thing is alter table is working fine.

Have u got any idea why doesn't work?

share|improve this question

2 Answers 2

Are you sure you have the ALTER ROUTINE privilege? See if you can create an own procedure and alter that.

share|improve this answer

here is a solution how I fixed this:

1) Add "mysql" database to the user, you are logged in with

Advice: now you can alter functions and procedures

2) Add the global privilege "SUPER" to your user

Advice: otherwise you will get the following error if you save the procedure/function: "ERROR 1227: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.