• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Enable a user to create function in mysql

Hi to all of you,
I have the following request :
could you kindly enable the feature to create functions in MySQL to user externalcomp?
could you please tell me how to do that  

Thank you
Carlettus
0
Carlo
Asked:
Carlo
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
http://dev.mysql.com/doc/refman/5.0/en/grant.html
this should do it:
GRANT CREATE ROUTINE TO 'externalcomp'@'somehost';
0
 
CarloAuthor Commented:
Hello,
thank you for your message. It was an excellent starting point. I made a correction and it worked as reported below:
grant create routine  on *.* to externalcomp@localhost IDENTIFIED BY 'password' ;

Thank you
Carlo
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now