mySQL stored function problem

Question

I'm defining a simple stored function which works fine in my local testing database, but when I try to create it on the "real" server, it just doesn't get added to the 'proc'-table. I'm getting no errors or anything, it just doesn't get added (hence, the function can't be used of course).

Both servers are using the same version, and I can't see any differences between the structures of the 'proc'-tables.

Any ideas? A permission problem?

Thanks.

EDIT: I tried to create the function in the mysql-shell instead of in phpMyAdmin, and that did the trick.

pixelwrench · Accepted Answer · 2010-02-10 09:51:30Z

3

Try checking in the error log file: usually /mysql.err on Windows, /hostname.err on Unix.

To debug permissions issues, run "SELECT * FROM user where host='hostname' and user='username'". More information on this here

answered Feb 10, 2010 at 9:51

pixelwrench

5,1802 gold badges35 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mySQL stored function problem

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related