debugging mysql stored function

motney · Post by **motney** » Thu 18 Oct 2007 14:00

Trying to debug a mysql stored function from within visual studio using the MyDeveloper Tools, it returns a permissions error and I have not been able to figure out how to set the permissions properly.

When I select 'Compile for debugging' it returns SELECT command denied for table 'debuggings'

What permissions am I missing? The user account connected to mysql should already have full permissions.

Elias · Post by **Elias** » Fri 19 Oct 2007 10:34

We examined your situation and the most probable problem is that the user who deployed debug engine now doesn't have SELECT privilege on cr_debug database. And cr_debug procedures use DEFINER for execution.

So please redeploy the debug engine under your user account or root.

Elias · Post by **Elias** » Fri 19 Oct 2007 10:41

In the next build of MyDeveloper, cr_debug procedures will use invoker for execution.

Elias · Post by **Elias** » Fri 19 Oct 2007 11:47

We recieved your letter about the problem. And we need some more information. What privileges does your account have on database cr_debug?