MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Having One and Only User But Having Not Admin Permissions
Posted by: Barry Galbraith
Date: June 25, 2023 11:19PM

I think the key here is the error code 1419.

https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html#error_er_binlog_create_routine_need_super

It looks like your server has BINLOG enabled. A CREATE TRIGGER statement will be written to BINLOG.
If server variable log_bin_trust_function_creators is set to OFF (default setting) a user must have SUPER privilege to create a stored proc, stored function, or a trigger.

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_log_bin_trust_function_creators

SUPER privilege is NOT included in GRANT ALL PRIVILEGES ...

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Having One and Only User But Having Not Admin Permissions
YILDIZ Recep
June 21, 2023 01:28AM
Re: Having One and Only User But Having Not Admin Permissions
Barry Galbraith
June 25, 2023 11:19PM
Re: Having One and Only User But Having Not Admin Permissions
Barry Galbraith
July 01, 2023 05:55AM
Re: Having One and Only User But Having Not Admin Permissions
Michael Smith
July 25, 2023 02:41PM
Re: Having One and Only User But Having Not Admin Permissions
Barry Galbraith
July 25, 2023 04:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.