Cannot create a function

Posted on 2012-08-17
Last Modified: 2012-08-17

I´m using MySQL v5.1, when I want to create a function on a DB I get the following error: #1044 - Access denied for user [..]

The user have been granted with the following permissions: INSERT, CREATE, DROP, DELETE according to the MySQL Website, to allow function creation only INSERT is needed (, what could be happening?

Question by:mzanlongo
    1 Comment
    LVL 24

    Accepted Solution

    The statement on that page is actually misleading - you need the INSERT privilege, but it's not the only one you need.  You need CREATE ROUTINE to create, EXECUTE to run the routines, and ALTER ROUTINE to modify or drop a routine.  See also

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now