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.
Reloading new privileges
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.
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.