Solved

Enable a user to create function in mysql

Posted on 2014-10-07
2
242 Views
Last Modified: 2014-10-09
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
Comment
Question by:carlettus
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40365444
http://dev.mysql.com/doc/refman/5.0/en/grant.html
this should do it:
GRANT CREATE ROUTINE TO 'externalcomp'@'somehost';
0
 

Author Comment

by:carlettus
ID: 40370242
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access - need to reduce row size 25 52
SQL View Syntax case etc 5 34
SQL Server Insert where not exists 24 41
MySQL Memory Keeps Increasing 4 34
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Creating and Managing Databases with phpMyAdmin in cPanel.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

785 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