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)
• Status: Duplicate
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.2.6 RC
• OS: Windows (XP)
• 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] MySQL Verification Team

Thank you for the bug report. Dplicate of bug:
http://bugs.mysql.com/bug.php?id=24613