distal-attribute
distal-attribute
distal-attribute
distal-attribute

Reloading new privileges

User, date Message
Written by cds
2 years ago
Category: General
1 posts since Sat, 31 Mar 12
i am trying to connect my database to my website control panel i have assigned the username and password. but when i connect to heidisql and try to change the privileges. it gives this error

* SQL Error (1227): Access denied; you need the RELOAD privilege for this operation */
pls tell me how i can go about this.
thanks.
Written by ansgar
2 years ago
5012 posts since Fri, 07 Apr 06
Well, you lack the RELOAD privilege for the FLUSH PRIVILEGE command. Without that priv you are not able to use HeidiSQL's user manager.
Written by gnaresh35
11 months ago
1 posts since Fri, 18 Oct 13
what is the solution for this problem
Written by jfalchMoney, Euro
11 months ago
400 posts since Sat, 17 Oct 09
someone has to modify your mysql user defintion, possibly using the heidsql user manager (in tools menu).
click the appropriate user (ie the one that you log on with); expand "Global Privileges" on the lower right side. scroll down, make sure that "Reload" is checked, and click "Save".

This will most probably work only if you are adminstrator to the server. if you are not, and it does not work (shows some error message or other), find someone who has administrative rights to the server, and ask that person to modify your mysql privileges.

if you are on a shared host (standard for-rent webspacer at some webhoster´s site), you are most probably out of luck. adminstrators of such shared servers will almost never grant elevated provileges to a user.
 

Please login to leave a reply, or register at first.