MySQL Bugs: #54262: Unable to view the routine when clicking on alter routine

Bug #54262	Unable to view the routine when clicking on alter routine
Submitted:	6 Jun 2010 2:26	Modified:	28 May 2012 12:17
Reporter:	akhil kumar	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.22, 5.2.40	OS:	Windows (revision 6091)
Assigned to:		CPU Architecture:	Any

Description:
the alter routine (right click on the routine) is not working, doesnt show up anything. was working fine on the previous builds.

How to repeat:
open any database instance
click on overview
in the routine section, right click on any routine 
click on the alter routine button

Akhil, what MySQL Server are you connecting to? i cant reproduce the problem with 5.x servers.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm using MySQL server version 5.1.62-rel13.3-log and Workbench 5.2.40 CE Revision 8790. I also see this behaviour, but only when my username & IP address combination don't match that specified in the "DEFINER" clause of the particular stored routine.

*** It would be good to see an error message displayed in Workbench to that effect. ***

I had a situation where all of my stored routines were created remotely when my workplace was using a particular static IP address, and the "DEFINER" clause reflected this. Subsequently, my part of the company was sold and we moved onto a new infrastructure with a new static IP address. This new IP address didn't match that found in the "DEFINER" clause and therefore I couldn't view the routine definition in Workbench nor phpMyAdmin. I suspect that Akhil's IP address has changed since he created his routine(s). This happens regularly if you are remotely connecting from a consumer Internet connection as the IP addresses assigned by ISPs are dynamic.

Can you provide the output for show grants and show create view for both accounts and the problematic view?