A.L.E.C pisze:

Konrad wrote:

...

*Błąd:* 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)

Użytkownik LMS ma wszystkie prawa do bazy danych LMS.

wygląda na to, że jednak nie ma, może usuń usera i dodaj jeszcze raz.

CREATE USER 'lms'@'%' IDENTIFIED BY PASSWORD '***';

GRANT USAGE ON * . * TO 'lms'@'%' IDENTIFIED BY PASSWORD '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT ALL PRIVILEGES ON `lms` . * TO 'lms'@'%' WITH GRANT OPTION ;

Tak będzie?

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms