Bug #24790 Administrator exception --> Can not create view or stored procedure.
Submitted: 4 Dec 2006 9:40 Modified: 4 Dec 2006 14:33
Reporter: Heinz Schweitzer (Gold Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.2.6 RC OS:Microsoft Windows (XP)
Assigned to: CPU Architecture:Any

[4 Dec 2006 9:40] Heinz Schweitzer
Description:
Administrator exception --> Can not create view or stored procedure.

Administrator exception generated trying to create a view or stored procedure

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Network Name:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Operating System:        Windows XP
  Hardware:                Intel(R) Pentium(R) M processor 1600MHz, 512 MB RAM

How to repeat:

OPen MA 1.2.6 RC
Selecet 'Catalogs'-->'mysql'
In the right pane activate tab 'views'
Try to create a view
You will be prompted for a name.
Enter any name and say 'Create View'

--> Exception see screenshot v2.png
[4 Dec 2006 9:40] Heinz Schweitzer
v2

Attachment: shot_2.jpg (image/jpeg, text), 80.58 KiB.

[4 Dec 2006 14:33] Miguel Solorzano
Thank you for the bug report. Dplicate of bug:
http://bugs.mysql.com/bug.php?id=24613