Why at command performance update MySQL we receive an error: " UPDATE command denied to user ' 89186_ **** ' ' 192.1 **.1. * ' for table ' gue " The rights of the user in norm.
K-Roy
Jan 27 2010, 09:40 PM
I've got a similar problem as well. In my case, I was trying to create a procedure from phpMyAdmin SQL query page.
I've granted all privileges (ticking all boxes) for my user from database management page.
here's the query I wrote btw:
CREATE DEFINER=`9****_(username)`@`localhost` PROCEDURE procedure_name() BEGIN SELECT ... FROM ... ORDER BY ...; END$$
I've specified $$ as the value in the delimiter text field below the query text area in phpMyADmin
ps: did try the hosting support in IRC, but got no reply =(
K-Roy
Jan 28 2010, 12:34 AM
*UPDATE*
Just got a reply from live-chat. Apparently, creating stored procedures is not a default privilege. So, if anybody really have to use stored procedures, then you better talk directly to the admin/op/moderator for a permission; either from here or from live chat. =)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.