how to add permissions to EXECUTE PROCEDUREs ?

[lightscribe]

Fatal error: Uncaught exception 'Exception' with message 'Error in DB RIS Query: execute command denied to user 'benitto_7'@'10.33.249.5' for routine 'benitto_control.TeraWurfl_RIS'. Query: CALL TeraWurfl_RIS('SonyEricssonK700i/R2AC SEMC-Browser/4.0.2 Profile/MIDP-2.0 Configuration/CLDC-1.1',16,'SonyEricsson') ' in /home/benitto/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:102 Stack trace: #0 /home/benitto/public_html/Tera-Wurfl/UserAgentMatchers/UserAgentMatcher.php(73): TeraWurflDatabase_MySQL5->getDeviceFromUA_RIS('SonyEricssonK70...', 16, Object(SonyEricssonUserAgentMatcher)) #1 /home/benitto/public_html/Tera-Wurfl/UserAgentMatchers/SonyEricssonUserAgentMatcher.php(29): UserAgentMatcher->risMatch('SonyEricssonK70...', 16) #2 /home/benitto/public_html/Tera-Wurfl/TeraWurfl.php(175): SonyEricssonUserAgentMatcher->applyConclusiveMatch('SonyEricssonK70...') #3 /home/benitto/public_html/Tera-Wurfl/TeraWurfl.php(303): TeraWurfl->getDeviceIDFromUALoose('SonyEricssonK70...') #4 /home/benitto/public_h in /home/benitto/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 102

 

[techairlines]

To add permissions for MySQL:

Go to cPanel --> MySQL Databases.

Drop the user from the database.

Add the user to the database again.

Click on ALL PRIVILEGES on the next screen and then finish.

Also make sure the host for your script is set to 'localhost'.

 

[lightscribe]

ok i'll try it tomorrow,mmm, but it doesnt show execute permission option there, and my user name already have all option available selected, wondering maybe i could add it manually somehow :/