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:Microsoft Windows (revision 6091)
Assigned to: CPU Architecture:Any

[6 Jun 2010 2:26] akhil kumar
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
[8 Jun 2010 11:59] Johannes Taxacher
Akhil, what MySQL Server are you connecting to? i cant reproduce the problem with 5.x servers.
[8 Jul 2010 23:00] Bugs System
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".
[22 May 2012 11:25] Clive Wickham
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.
[26 May 2012 16:41] Alfredo Kojima
Can you provide the output for show grants and show create view for both accounts and the problematic view?