Bug #17492 SHOW EVENTS shows only events created by current user
Submitted: 16 Feb 2006 19:29 Modified: 5 May 2006 8:23
Reporter: Markus Popp Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.6/5.1.7 BK OS:Linux (Linux)
Assigned to: Andrey Hristov CPU Architecture:Any

[16 Feb 2006 19:29] Markus Popp
Description:
SHOW EVENTS doesn't show events that are created by another user, even if the current user has full privileges.

How to repeat:
Create an event by user A, log in as user B (who also has privileges for the database, where the event was created) and issue a SHOW EVENTS command. It will return an empty set.

Suggested fix:
SHOW EVENTS should show events that are created by other users as well, given that the user has sufficient privileges.
[16 Feb 2006 19:33] Andrey Hristov
Could you try SHOW FULL EVENTS ?
[16 Feb 2006 19:40] Markus Popp
Same result:

linux:~ # mysql -h 127.0.0.1 -P 3307 -u user
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1438 to server version: 5.1.7-beta-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show full events;
Empty set (0.01 sec)

mysql> exit
Bye
linux:~ # mysql -h 127.0.0.1 -P 3307 -u mpopp
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1439 to server version: 5.1.7-beta-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show full events\G
*************************** 1. row ***************************
            Db: test
          Name: insertIntoTt
       Definer: mpopp@%
          Type: RECURRING
    Execute at: NULL
Interval value: 5
Interval field: INTERVAL_SECOND
        Starts: 2006-02-13 17:53:32
          Ends: 0000-00-00 00:00:00
        Status: DISABLED
1 row in set (0.01 sec)

mysql>
[16 Feb 2006 22:59] MySQL Verification Team
Thank you for the bug report.

miguel@hegel:~/dbs/5.1> bin/mysql -uroot db1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.7-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on db1.* to 'userdb1'@'localhost' identified by 'userdb1';
Query OK, 0 rows affected (0.00 sec)

mysql> create event lk on schedule every 1 second do insert into t values
    -> (0);
Query OK, 1 row affected (0.00 sec)

mysql> show full events\G
*************************** 1. row ***************************
            Db: db1
          Name: lk
       Definer: root@localhost
          Type: RECURRING
    Execute at: NULL
Interval value: 1
Interval field: SECOND
        Starts: 0000-00-00 00:00:00
          Ends: 0000-00-00 00:00:00
        Status: ENABLED
1 row in set (0.01 sec)

mysql> 

miguel@hegel:~/dbs/5.1> bin/mysql -uuserdb1 -puserdb1 db1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.1.7-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show full events\G
Empty set (0.01 sec)

mysql>
[18 Feb 2006 22:32] Andrey Hristov
Most probable will be fixed with the fix for #16992 . Not marking as dupe.
[5 May 2006 8:23] Andrey Hristov
Fix for bug #17394 will fix this