MySQL Bugs: #42260: TRIGGER privilege for user 'root'@'%'

Bug #42260	TRIGGER privilege for user 'root'@'%'
Submitted:	22 Jan 2009 7:56	Modified:	12 Jun 2009 8:41
Reporter:	Olivier KOVACS	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	5.1.30	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	privilege, trigger

Description:
running mysql from a command lines windows with the root password connect to mysql as 'root'@'%'. this user doesn't have the TRIGGER privilege even if root.

Turn over : 
run "MySQL command line client" on the mysql server (connected as 'root'@'localhost'), grant the TRIGGER privilege to 'root'@'%' WITH GRANT OPTION.

How to repeat:
running mysql from a command lines windows with the root password connect to mysql as 'root'@'%'. this user doesn't have the TRIGGER privilege even if root.

Turn over : 
run "MySQL command line client" on the mysql server (connected as 'root'@'localhost'), grant the TRIGGER privilege to 'root'@'%' WITH GRANT OPTION.

Suggested fix:
add the TRIGGER privilege to the default 'root'@'%' user.

A more correct description is:

After mySQL server installation (root password changed and checkbox 'Allow access from remote hosts' checked), user 'root'@'%' doesn't have the TRIGGER and EVENT global privileges. The user 'root'@'localhost' which is also created has all global privileges. 

The result is that when 'root'@'%' tries to grant TRIGGER and/or EVENT it fails:

mysql> GRANT TRIGGER ON *.* TO testuser IDENTIFIED BY 'mumu';
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

The strange thing is that using the 'MySQL Administrator' GUI the root@any_host is able to grant TRIGGER and EVENT to himself and other users.

mySQL Server 5.1.32 for Windows
mySQL Administrator 1.2.17 for Windows

This is a duplicate of bug #41313, it seems.