How do i create TRIGGER ?

[Tom Tom]

help me !

i try, create TRIGGER in Cloud SQL MySQL.

i set

log_bin_trust_function_creators is ON

and set query.

but error, error message is

1044 - Access denied for user 'root'@'%' to database 'information_schema'

and i try this command.

grant all privileges on *.* to 'root'@'%' with grant option;

help me !

tom...@gmail.com

[Felipe Bergallo Corral]

Hey there,

According to the commands you've stated, you've not mentioned whether or not you've flushed these permissions, so if you've not done that, then please do.

I would also like to know why log_bin_trust_function_creators was set to on when that's mostly for binary files, and what it is that you mean by "set query"? I can guess that you mean that you attempted to set the trigger, but I can't be sure.

I'd also like to note that root is meant to serve as an administrator and shouldn't have access to the data inside of tables, that's why it doesn't have access to inserting, updating or deleting the information on 'information_schema'

May I ask what it is that you are trying to accomplish

[Felipe Bergallo Corral]

"May I ask what it is that you are trying to accomplish?"*
(I forgot the interrogation mark, pardon)