SLiMS: mengatasi Error You do not have the SUPER privilege and binary logging is enabled

Jika mendapati error saat menginstall SLiMS (Senayan Library Management System), seperti berikut

Error You do not have the SUPER privilege and binary logging is enabled

Berikut solusi untuk mengatasinya:

Masuk ke MySQL console sebagai root

mysql -uroot -p

Paste perintah berikut dan Enter

set global log_bin_trust_function_creators=1;

Alternatif, bisa diset permanent melalui konfigurasi my.cnf pada block [mysqld] paste baris berikut:

log_bin_trust_function_creators=1

Restart MySQL, service mysql restart

Selesai.

Leave a Reply

Your email address will not be published. Required fields are marked *