How to Fix MySQL/MariaDB Error SQLSTATE[HY000] 1419 – you do not have the SUPER privilege and binary logging is enabled

In this article, I will show you how to fix the following MySQL/MariaDB error:

SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)  

Grant MySQL/MariaDB User SUPER Privilege

To fix the issue, log in to your MySQL/MariaDB database as root user and grant SUPER privilege to your MySQL/MariaDB user (magento_dev@localhost in this case) using the following SQL statement:

mysql> GRANT SUPER ON *.* TO 'magento_dev'@'localhost';

For the changes to take effect, flush the database privileges with the following SQL statement:

mysql> FLUSH PRIVILEGES;