Stored procedure problem:

[robotledesma913]

execute command denied to user 'xxxxxxxxxxxx'@'10.33.248.%' for routine 'xxxxxxxxxxxxxxx.catalog_count_products_on_catalog'

I have made a user for this database and granted all privilleges that is available on the cpanel, but still I got this error... Any suggestions?

 

[techairlines]

Go to cPanel --> Databases. Make sure the Remote Hosts list looks something like:

10.33.248.%
10.33.249.2
192.168.1.%
int.stoli.x10hosting.com
int.mysql.x10hosting.com

If any host above is missing, please add it.

 

[descalzo]

I am assuming that you added the stored procedure via phpMyAdmin, either via SQL or by importing.

If you notice when you add a user to a database it has CREATE ROUTINE privileges. Not EXECUTE ROUTINE.

So he does not have privileges to run other users routines. And the user that creates routines via phpMyAdmin is not the user you created.

The way around it is that the creator of a routine always can execute the routine.

So, write a PHP/Perl script that connects to the database using your user and then creates your routine.

Then that user will be able to execute it.