Devart Forums

Hi,
While trying to debug a function, I received the following message:
"The error happend using the Debug Engine. It may be corrupted.
Please redeploy the debug engine or contact Devart support.
The original exception message:
'execute command denied to user ''@'localhost' for routine 'cr_debug.ENTER_MODULE'"

I redeployed the debug engine but the issue still remains.
The following screenshots show the steps performed in debugging the function:

The first screenshot appeared after choosing Start Debugging (Ctrl + F5)
1. http://i47.tinypic.com/20a9h7c.png

The second screenshot appeared after pressing the OK button of Edit Parameters Dialog Box.
2. http://i48.tinypic.com/1zedxxj.png

The third screenshot appeared after pressing the OK button of the message.
3. http://i49.tinypic.com/fngjp.png

I don’t know neither the reason for this original exception message
(‘execute command denied to user ''@'localhost' for routine 'cr_debug.ENTER_MODULE'), nor the solution.

I would be grateful if you could explain me what should be filled into value cell of the Result parameter.

Thank you in advance.

Hello.
The ''@'localhost' user does not have the EXECUTE global privilege. You need to login as root@localhost (system administrator) and grant the EXECUTE privilege to your ''@'localhost' user:
GRANT EXECUTE ON *.* TO ''@'localhost';
or you can grant all privileges to your user:
GRANT ALL PRIVILEGES ON *.* TO ''@'localhost';
After that you can login as ''@'localhost' and debug any stored routines.

I would be grateful if you could explain me what should be filled into value cell of the Result parameter.

You can not enter a value into the cell of the Result parameter because the result of the function execution will be displayed in this cell. It is read only.

vu,
Thank you very much for your prompt assistance.
Your answer did help me.