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: | |
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
[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