user account has insufficient privileges to use the debugging engine database

[mmaximov]

Hi,

I downloaded and installed "dbForge Studio for MySQL Professional Edition - Trial v5.0.76".
I am using MySQL 5.5.20.
Everything was OK till the moment I tried to debug a function using the dbForge Studio debug engine.

When attempting to compile for debugging I get the following message:
"Your user account has insufficient privileges to use the debugging engine database.
Check privileges on database cr_debug on your server using Security Manager
or contact your database administrator."

I tried to redeploy the debug engine, using the Debug/Deploy Debug Engine menu command,
but I received the same message again.

I can't manage my account privileges using the Security Manager, because it's not active.
After trying to use it, I get the following message:
"SELECT command denied to user ''@'localhost' for table 'user'"

I don't know how to solve this issue.
I would be glad if anybody could help me in solving this issue.

Thank you in advance.

[.jp]

Hello,
Thanks for the post.

This problem appears because your user does not have enough privileges. You have to login under another user, for example, as administrator, or contact your system administrator. Your system administrator should give you more privileges.
For more information, open Help -> Contents from the main menu and look at the Debugging -> Debugging Stored Routines -> Stored Routine Debugging Concepts topic.

Best Regards,
Devart Support Team

[mmaximov]

Dear .jp,

After reading your answer, I don't know what to do - to laugh or to cry.
"This problem appears because your user does not have enough privileges."
Of course that I don't have enough privileges - everybody (even a complete idiot) could realize this from the message: "Your user account has insufficient privileges to use the debugging engine database."

"You have to login under another user, for example, as administrator, or contact your system administrator."
I have already logined as administrator, but the issue still remains.

"Your system administrator should give you more privileges"
I don't have system administrator as I am the owner of my laptop.

"For more information, open Help -> Contents from the main menu and look at the Debugging ->Debugging Stored Routines -> Stored Routine Debugging Concepts topic.
I have already got familiar with the above mentioned 'Stored Routine Debugging Concepts' topic but I couldn't find the answer to the issue.

"To debug a stored routine, you must have ALTER ROUTINE and EXECUTE privilege on the stored routine to debug, CREATE ROUTINE privilege on the database the routine belongs to, and SELECT, INSERT, UPDATE, DELETE, EXECUTE privilege on the cr_debug database, which contains the stored routine debug engine."

"To deploy debug engine you need to have PROCESS global privilege and the following privileges on cr_debug database (or global ones):

SELECT
CREATE
DROP
CREATE ROUTINE"

How could I get 'PROCESS global privilege' and 'SELECT, CREATE, DROP, CREATE ROUTINE priviledges' on cr_debug database?

Could you please, be much more specific providing the necessary mysql code sample?

[.jp]

Thanks for the reply.
The user under which you connect to MySQL server has limited privileges. Get familiar with your accounts. When you install the MySQL server, the server itself creates the root user who is its administrator, i.e. has all privileges. Also, the server itself offers you a password for root during installation. Use the account root.

[mmaximov]

Dear .jp,
Thank you very much for your assistance.
It turned out that the issue had resulted from the login under user account with insufficient privileges.
Having logged in under root account, I gained sufficient privileges to use the debugging engine database.