I uploaded the database to my host server. The database is mysql v:5.1.52.
When I run the following command:
SHOW GRANTS
The result is:
Grants for espira_smuser@localhost’ => 'GRANT USAGE ON . TO ‘espira_smuser’@‘localhost’ IDENTIFIED BY PASSWORD '**’
Grants for espira_smuser@localhost’ => 'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON espira\\\\_sigmanager. TO ‘espira_smuser’@‘localhost’
Grants for espira_smuser@localhost’ => 'GRANT EXECUTE ON espira_sigmanager. TO ‘espira_smuser’@‘localhost’
According to above result, my connection has the Execute privilege, but when I try to execute the following command:
CALL test()
The result is:
execute command denied to user ‘espira_smuser’@‘localhost’ for routine ‘espira_sigmanager.test’
Do you have any idea about that? Why I am unable to call a stored procedure, although I have the Execute privilege ?