Help - Search - Members - Calendar
Full Version: Update Command Denied To User '89186_****'@'192.1**.1.*' For Table 'gue
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
DanUnited
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.
blink.gif
K-Roy
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
*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.
Invision Power Board © 2001-2012 Invision Power Services, Inc.