I start mysql with

mysql -u root -p

and enter the password.

However when I try to run a procedure like:

use foo;
call bar();

it says "Access denied to user ''@'server' for routine 'foo.bar'"

It does this with any account, even after I have granted execute to the procedure. Does anyone know why it executes with a blank user and how to fix this?

link|improve this question
Possibly best moved to Stackoverflow – Linker3000 Jan 28 '11 at 12:42
@Linker3000 Why move it to Stack Overflow? It's a permissions problem and I see no reason why it shouldn't stay right here. – Diago Jan 28 '11 at 12:49
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.