error happend using the Debug Engine

[mmaximov]

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.

[vu]

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.

[mmaximov]

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