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
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
On Tuesday, May 4, 2021 at 10:22:53 AM UTC+2 tom...@gmail.com wrote:
help me !i try, create TRIGGER in Cloud SQL MySQL.i setlog_bin_trust_function_creators is ONand set query.but error, error message is1044 - 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 !
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0f652339-7581-4fa3-9616-9df5bbc7bf33n%40googlegroups.com.
No comments:
Post a Comment