Forums

Hi

mysql returns ERROR 1419 (HY000) You do not have the SUPER privilege and binary logging is enabled.

I'm trying to create a UDF,like this:

delimiter //
CREATE FUNCTION myfunc_name(
    p_a INT,
    p_b INT
) RETURNS int(11)
READS SQL DATA NOT DETERMINISTIC
BEGIN
    declare ret INT;
    select count(id)
    into ret
    from my_table
    where key_a = p_a
    and key_b = p_b;

    return ret;
END//
delimiter ;

How can I fix ti?

Looks like our current setup doesn't allow user-defined functions. I'll have a chat with my colleagues on Monday, maybe it's a restriction we can relax...

Any fix to this? I'm having the same issues. :S

I don't think we're ever going to support UDFs since they are for an entire MySQL server.

Could a user create their own Amazon mySQL database and use that with PythonAnywhere to solve the problem? Is there an issue with security zones?

That could work for a paying account. It would mean that database would have its database port open to the internet, though.