Reloading new privileges

cds posted 6 years ago in General
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.
ansgar posted 6 years ago
Well, you lack the RELOAD privilege for the FLUSH PRIVILEGE command. Without that priv you are not able to use HeidiSQL's user manager.
gnaresh35 posted 4 years ago
what is the solution for this problem
jfalch posted 4 years ago
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.