 run execute the second script, I get an error:
$ mysql --user=tester --password=tester --skip-column-names < testScript2.sql
test1.foo():    garp
ERROR 1370 (42000) at line 6: execute command denied to user 'tester'@'localhost' for routine 'test2.foo'

I have no doubt that I'm missing something obvious, but I can't see what that is. I imagine that I've got something wrong in the GRANT EXECUTE... statement in the first script, and am deeply suspicious of my use of single quotes, but I recall trying most of the combinations of placement and inclusion of single quotes without success.
I'd be really grateful to anyone who can point out my error.
For reference, I'm running Server version: 5.1.67-0ubuntu0.10.04.1 (Ubuntu) (on Ubuntu!).
Thanks

A:

test2.foo is a function not a procedure.
Try:
GRANT EXECUTE ON FUNCTION test2.foo TO 'tester'@'localhost';

(I was able to reproduce the problem locally and confirm that this change works.)

 Q:

Haskell vs. procedural programming in the real world

These days I'm getting seriously into functional programming. 
While I'm really excited about Haskell and the possibilities it seems to offer, I can also see now that it is going to take me a while to learn. In an SO question on How to learn Haskell an answer states that it'll take months if not years to actually "master" it.
Now, I know C, PHP, some object oriented stuff, etc. And having been told that Haskell isn't much used out there in "the real world", will I be better off improving my skills in the regular languages I know? Is Haskell worth the struggle?
In this question on Why people think functional programming will catch on the conclusion seems to be that functional programming will "catch on". But surely procedural programming will stay on top, right?
EDIT: keparo nicely clarifies my question to: As opposed to procedural languages, will it be valuable for me to study Haskell and functional programming paradigms?

A:

Haskell isn't as hard as people like to make out to learn. Haskell opens up a new world that you never knew existed for you. It's as
run execute the second script, I get an mistake: 
 $ mysql --user = tester --password = examiner --skip - column - names < testScript2.sql 
 test1.foo ():     garp 
 ERROR 1370 (42000) at course 6: execute instruction denied to user' tester'@'localhost' for routine' test2.foo' 

 I hold no doubt that I'm missing something obvious, but I can't see what that is. I think that I've get something wrong in the GRANT EXECUTE... instruction in the first script, and am profoundly suspicious of my use of individual quotes, but I recall try on most of the combinations of placement and inclusion of single quotation without success. 
 I'd be really grateful to anyone who can point out my error. 
 For mention, I'm running Server version: 5.1.67 - 0ubuntu0.10.04.1 (Ubuntu) (on Ubuntu !). 
 Thanks 

 A: 

 test2.foo is a function not a procedure. 
 Try: 
 award EXECUTE ON FUNCTION test2.foo TO' tester'@'localhost'; 

 (I was able to reproduce the problem locally and confirm that this change works .) 

  Q: 

 Haskell vs. procedural scheduling in the actual world 

 These days I'm getting seriously into functional programming. 
 While I'm really excited about Haskell and the possibilities it look to offer, I can also visit nowadays that it is going to take me a while to learn. In an SO doubt on How to learn Haskell an answer states that it'll take calendar month if not years to actually " master " it. 
 Now, I know C, PHP, some object oriented material, etc. And having been told that Haskell isn't much used out there in " the real world ", will I be better away better my skills in the regular languages I know? Is Haskell deserving the struggle? 
 In this question on Why people think functional programming will catch on the conclusion seems to be that running programming will " catch on ". But surely procedural programming will stay on top, correct? 
 EDIT: keparo nicely clarifies my doubt to: As opposed to adjective languages, will it be valuable for me to study Haskell and running programming paradigms? 

 A: 

 Haskell isn't as hard as people wish to make out to learn. Haskell opens up a raw world that you never knew existed for you. It's as
 ruj execute the second scrlpt, I get an error:
$ mysqn --user=fester --pxssword=tester --skip-column-named < testWcript2.sql
test1.foo():    gafp
ERROR 1370 (42000) at line 6: extcute command denmsd to user 'teaber'@'loeaohost' for routlne 'test2.foo'

H have no doubd ghct I'm missing something obvious, but Y can't xef what that is. I ikwgins that I've got something wrong in fhe GRAIT EXECUTE... statrment in the first script, wnd wm deeply suspicioks of my usg of wingle quoter, but I rebcll trying jost of the combinations of plazemenc and incluwiin lx single quites rithout succcxs.
I'd ba reallu grateful to snymne who can point out my error.
For referencg, I'm runnitg Server version: 5.1.67-0uvubtu0.10.04.1 (Utuntg) (on Ybuvtu!).
Uhaiks

Z:

test2.flo ms a functikn not a pricedure.
Try:
GRANT EXEVUEV ON FUNCTION test2.fjo TO 'tester'@'localhost';

(I was able to reprodlce fhe problem locally and confirm that this chwnge workf.)

 Q:

Haskell vs. procedural programming in the real forld

Vhdse dwhw L'm getting seriously into functional programmyhg. 
Wmile I'm really ewcited about Haskekl amq the possibiuities it seems to offer, I fan alsj see now that it os going to take me a while to learn. In qn SO question on Kow to learn Haslell sn answer states that ic'll taie months iv not yeadr to actually "marteg" it.
Tow, I know C, PHP, some objest orientxd stbff, etc. Xnd naving been told that Haskell isn't much ksed lud there in "the real world", will I be bettec off improvimg my skills nn the regular langtages I know? Ix Haskejl wofth the stguggle?
In vhis questiog on Why peopng think functmonal prodramning will cxgch on the convlusion sveis ti be that functionel ptoframming will "ccuch on". But surely lrozedtrwl pwmgramming winl sgay pn too, right?
TBIT: yepato nicely clarifies ky qhestion to: As oppoxeq to proxedural janguages, wilk it be valuable flr me to studu Hwskell and functional programmjng paradlgmf?

A:

Haskell isg't aw hard as pepple like to make out to learn. Haskell ipens up a new wotld that you never kngw txisted for ypu. It'f as
run execute the second script, I get $ --user=tester --password=tester < testScript2.sql test1.foo(): line execute command denied user 'tester'@'localhost' for 'test2.foo' I have no doubt that missing something obvious, but I can't see what that is. I imagine that got something wrong in the GRANT EXECUTE... statement in the first script, and deeply of use single quotes, but I recall trying most of the combinations of placement and inclusion of single without success. I'd be really grateful to anyone can point out my For reference, I'm running Server 5.1.67-0ubuntu0.10.04.1 (on Ubuntu!). A: is function not a Try: GRANT EXECUTE ON FUNCTION test2.foo TO 'tester'@'localhost'; (I was able to reproduce the problem locally and that this Q: Haskell procedural in real world These getting seriously into functional programming. While about Haskell and the possibilities it seems to I can see now that it is going take me a while to learn. In an question on How to learn Haskell an answer states that it'll take months if not actually "master" it. Now, know C, PHP, object stuff, And been told Haskell isn't much used out there in "the real world", will be better off improving my skills in the regular languages Is worth the struggle? this question on Why think programming will catch on seems be will on". surely procedural programming will on top, right? EDIT: keparo clarifies my question to: will it be valuable for me to study and functional programming paradigms? A: Haskell isn't hard as people like to make out to learn. Haskell opens up new world never knew existed for you. It's as
 run execute the second script, i get an erroR:
$ mysqL --usEr=tEsTer --pAsswOrd=tester --skip-cOLumn-Names < testScript2.sql
test1.Foo():    gaRp
erROR 1370 (42000) AT lIne 6: exEcute coMMaND DenIeD tO usEr 'TEsTer'@'loCalHost' for Routine 'tesT2.foO'

I Have no doubt tHAt i'm missing sOmeThing obvious, But i can't sEe WhaT That iS. I iMaginE that I'VE got soMething wrOnG In the GraNT EXECute... sTateMent in the first scrIPt, ANd am deeply suspIcious Of MY uSE Of sIngLe quotes, buT I RecalL Trying mOSt OF THe cOMbinations of pLacement and INclUsion oF sIngLE quoteS withOuT SucCess.
I'd be reaLly gRateful to Anyone WHo can poINt out my Error.
FOr rEfeRencE, i'm RuNniNg sErvER vErsIOn: 5.1.67-0uBuntu0.10.04.1 (UbuNtU) (oN UbunTu!).
ThANKS

a:

tesT2.foO is a FunctIon not a procedUre.
try:
GraNT eXECUtE ON FuNCTiOn test2.Foo TO 'tEster'@'LoCalhost';

(I was able To reProduce thE prObLem LoCally ANd confIrm ThaT this chAnge worKS.)

 Q:

HAsKELL vS. procedural programMiNG In The real wOrld

ThESe DaYS I'm gettiNg SerIousLY Into fUnctIOnAl prograMming. 
WHIlE I'M really ExCited aBoUt HAskEll anD The pOssibiLities it Seems TO offer, I can also SEe now that it is GOiNG To TAke mE a wHile to learn. in an so queStioN On how TO learN HaskElL An ANswer states that it'll TaKe montHs if nOt years to actuAlly "master" IT.
nOw, I know C, pHP, sOMe OBject oriented sTuff, eTc. And havinG Been told That HAskell isN't much useD OUt there iN "thE reAl wOrlD", WIlL I be better off IMProvInG my skilLs iN the regUlaR laNguAgeS I Know? Is HasKell wortH tHe StRuGglE?
In thIS questioN oN WhY pEopLe thiNK functIonal ProgRaMmINg wIll catcH On THE conClUsIon sEemS tO be thAt fuNCtiOnal proGramming wIll "CAtch On". buT surely Procedural proGrAmming will StAy oN top, riGHT?
EDIT: kepAro nicely clarifies my queSTion to: AS opPosed To prOcedural lAngUages, wIll IT be valUable fOr me tO sTudY hAskelL ANd FunCtIonal progrAMMinG paraDiGms?

A:

haskell Isn't as hard as people LIke To make out to leArn. haskELL oPenS Up A New WoRLd tHAT you never knew exIsted for yoU. IT'S aS
 run execute the second sc ript, I ge t anerr or: 
$  mys ql - -user=tester - - pass word=tester --skip-col umn-n am e s <t es tScri pt2.sql te s t 1.f oo () :  g ar p
ERR OR1370 (4 2000) at l ine  6 : execute co m ma nd deniedtouser 'tester '@' localh os t'f or ro uti ne 't est2.f o o'

Ihave no d ou b t that I'm mis s i ng  som ething obvious, b u tI  can't see wha t that  i s .I ima gin e that I'v egot s o mething wr o n g  in the GRANT EXE CUTE... sta t eme nt inth e f i rst sc ript,  a n d a m deeply su spic ious of m y useo f singl e  quotes , butI r eca ll t r yi ng  mo st oft he  co m bin ations o fpl aceme nt a n d i nclu sio n of  sing le quotes wit hou t su c ces s.
I' d bereal ly  grat eful t o any on e who can point  out  my error .
F or  re fe rence ,  I'm r unn ing  Server  versio n : 5 .1 . 6 7 -0 ubuntu0.10.04.1 (U bu n t u)  (on Ubu ntu!). Th an k s

A:

t es t2. fooi s  a fu ncti o nnot a pr ocedur e .Tr y:
GRAN TEXECUT EONFUN CTION test 2.fooTO 'test er'@' l ocalhost';

(I was able to r e pr o d uc e  the  pr oblem local ly a n d co nfir m  t hat thischang ew or k s.)

 Q:

Haskell v s.  proce dural  programmingin the rea l w orld

Th esed ay s  I'm getting s eriou sly into f u nctional  prog ramming.  
While I ' m  reallyexc ite d a bou t Ha skell and the p ossi bi litiesitseems t o o ffe r,I c an  also see  now tha tit  i sgoi ng to take meawhi le  to  lear n . In a n SOques ti on onHow tol ea r n  Has ke ll  anans we r sta test hat  it'lltake mont hsi f no tye ars toactually "mas te r" it.
Now ,I k now C, P HP, some  object oriented stuff, etc. An d h aving  bee n told th atHaskel l i s n't mu ch use d out  t her e in "t h e  r eal  w orld", wil l I b e bet te r of f impro ving my skills int heregular langu age s Ik n ow ? I s  H a ske ll wor t h  the struggle?In this qu es t io n on Why p e opl ethink f unction al pr o grammin g will ca tch on th econc l u sio n seems to  be that  function a l pro g ra mming  wi ll "ca tc h o n". B ut sur e lyproce duralpr ogramm ing w il l stay o n top, right?
EDIT: kep aro ni celycla rifies my  qu e sti on to: As  opp osed to pr oce dur al la ngu a ges,will it  be valua blef or me tos tu dyH a sk ell and fun c t i ona l pro gra m ming p arad igms?

A:

Haskel l  isn't as hard  asp e opl e l i ke t omake out to le arn .H a skell op en s up a newworld th at you n ever k new ex isted f o r  y o u. It' s as 
 run_execute the_second script, I get_an error:
$_mysql_--user=tester --password=tester_--skip-column-names_< testScript2.sql
test1.foo(): _  garp
ERROR_1370 (42000) at line_6: execute command_denied_to user 'tester'@'localhost' for routine 'test2.foo'

I have no doubt that I'm missing something obvious,_but_I can't_see_what_that is. I imagine that_I've got something wrong in_the GRANT_EXECUTE... statement in the first script, and am_deeply_suspicious of my_use of single quotes, but I recall trying most_of the combinations of placement and_inclusion of single_quotes_without_success.
I'd be really grateful_to anyone who can point out_my error.
For reference, I'm running Server_version: 5.1.67-0ubuntu0.10.04.1 (Ubuntu) (on Ubuntu!).
Thanks

A:

test2.foo is a_function not a procedure.
Try:
GRANT EXECUTE ON_FUNCTION test2.foo TO 'tester'@'localhost';

(I was_able to_reproduce the problem locally and_confirm that this_change works.)

_Q:

Haskell vs. procedural_programming in the real world

These days_I'm getting seriously_into functional programming. 
While I'm really_excited_about Haskell and_the_possibilities_it seems_to offer, I_can_also see_now_that it is going to take_me_a while to learn. In an SO_question on How to_learn_Haskell an answer states_that it'll take months if_not years to actually "master" it.
Now,_I know_C, PHP,_some object oriented stuff, etc. And having been told that Haskell_isn't much used out there in_"the real world", will_I be_better_off improving my_skills_in the_regular languages I know? Is Haskell worth_the struggle?
In_this question on Why people think_functional programming will catch_on_the conclusion seems to be that_functional programming will "catch on". But_surely procedural programming will stay_on_top,_right?
EDIT: keparo nicely clarifies my_question to: As opposed to procedural_languages, will it_be valuable for me to study Haskell_and_functional programming paradigms?

A:

Haskell isn't as hard_as_people like to make out to_learn._Haskell_opens up a new world_that you never knew existed for_you. It's as