Reloading new privileges

[expired user #6324]'s profile image [expired user #6324] posted 12 years ago in General Permalink
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.
ansgar's profile image ansgar posted 12 years ago Permalink
Well, you lack the RELOAD privilege for the FLUSH PRIVILEGE command. Without that priv you are not able to use HeidiSQL's user manager.
[expired user #7339]'s profile image [expired user #7339] posted 11 years ago Permalink
what is the solution for this problem
jfalch's profile image jfalch posted 11 years ago Permalink
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.