Bug #45959 Access denied for user 'root'@'localhost' to database 'information_schema'

• Submitted: 6 Jul 2009 6:50
• Modified: 6 Jul 2009 10:11
• Reporter: Chirag Fisher
• Status: Closed
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.1.35
• OS: Windows (XP Sp 3)
• CPU Architecture: Any
• Tags: Access denied for user 'root'@'localhost'

[6 Jul 2009 6:50] Chirag Fisher

Description:
ERROR No. 1044
"Access denied for user 'root'@'localhost' to database 'information_schema'" Error message was dispalyed.

It allows to create a event but same user cant delete or alter it.

i am using ROOT as Super admin
-------------------------------------------------------------------------
SHOW GRANTS FOR 'root'@'localhost';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'Encryted pass word' WITH GRANT OPTION
-------------------------------------------------------------------------

How to repeat:
I logged in as root

I created a event, When i tried to alter it.

ERROR No. 1044
"Access denied for user 'root'@'localhost' to database 'information_schema'" Error message was dispalyed.

I tried to delete/drop it i still gave me the ERROR.

[6 Jul 2009 7:06] Sveta Smirnova

Thank you for the report.

Did you create EVENT in INFORMATION_SCHEMA?

[6 Jul 2009 7:20] Chirag Fisher

delimiter |
CREATE EVENT e_daily_morning
ON SCHEDULE AT '2009-07-06 05:10:00' + INTERVAL 24 HOUR

DO
    BEGIN
       Update ........ a cell in amruth database.. NOT information schema
END |
delimiter ;

I need to add a event so that it fires every day at 5 am till 3 years

[6 Jul 2009 8:46] Sveta Smirnova

Thank you for the feedback.

Did you run USE database before running CREATE EVENT?

[6 Jul 2009 8:55] Chirag Fisher

Yes i did

[6 Jul 2009 9:03] Sveta Smirnova

Did you issue USE information_schema before CREATE EVENT or before ALTER EVENT?

[6 Jul 2009 9:33] Chirag Fisher

No i Didn't use information_schema before CREATE EVENT or before ALTER
EVENT?

[6 Jul 2009 9:39] Sveta Smirnova

Thank you for the feedback.

I can not repeat described behavior if do CREATE/ALTER event in regular database:

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> CREATE EVENT e_daily_morning ON SCHEDULE AT '2009-07-06 05:10:00' + INTERVAL 24 HOUR  DO     BEGIN select 1; END|
Query OK, 0 rows affected (0.25 sec)

mysql> alter event e_daily_morning ON SCHEDULE AT '2009-07-06 05:10:00' + INTERVAL 24 HOUR  DO     BEGIN select 12; end|
Query OK, 0 rows affected (0.07 sec)

mysql> delimiter ;
mysql> drop event  e_daily_morning;
Query OK, 0 rows affected (0.05 sec)

Please provide your step-by-step actions including USE statements, so we can recreate the problem. Also, please, provide your configuration and error log files.

[6 Jul 2009 10:11] Chirag Fisher

Thank You Sveta Smirnova!
i will marked this issue as close if i get a break through, I will report it.

Thanks & regards
Chirag Fisher

[19 Aug 2009 20:38] Martin rebane

tty

Attachment: localhost.sql.zip (application/octet-stream, text), 143.62 KiB.