Error! Need help... :(

Ok.. So i can connect fine to HeidiSQL if i use the IP 127.0.0.1 but then i downloaded Hamachi and set up my new ip so my friends could play... Well i tryed making custom items( WoW ) and every time i tryed to get them on my game it never worked.. so i figured i needed to update the ip to my new ip.. so i try that and i get a error.. i have been looking around for hours to try to fix this but i dont understand it at all.. so i am going to post what it says and if some one can simply tell me a solution that isnt to in-depth that would be awesome!

Could not establish connection! Details:
SQL Error: Host ' ( my computer's name ) ' is not allowed to connect to this mySQL server

:(

simply tell me a solution that isnt too in-depth

UPDATE mysql.user SET Host='%' WHERE User='root'

Legend:
"%" meaning any host allowed, "root" being the user name you connect to MySQL Server with.

(edit: alter table --> update)

ALTER TABLE mysql.user SET Host='%' WHERE User='root'

Where can i enter this code?

Where can i enter this code?

Query pane.

ok well i wasnt sure how to get into it.. so i went back to the old ip 127.0.0.1 went to query and entered that in.. not sure if thats what i was sopose to do but i didint do anything not sure if theres something i have to press to enter it.

i highlighted it all in query and right clicked and went to run. but i got another error saying..


Sql error: you have an error in your SQL syntax; check the manual that corresponds your MySQL server version for the right syntax to use near " SET host ='%' WHERE user='root" at line 1

... of course you pressed F9 or the blue "Play" button to execute the SQL did you?

Sql error: you have an error in your SQL syntax; check the manual that corresponds your MySQL server version for the right syntax to use near " SET host ='%' WHERE user='root" at line 1

Thats what happend

Ok, try this instead:

UPDATE mysql.user SET Host='%' WHERE User='root'

OK i tryed that.. something happend, i did not get an error.. now should i try to log on with my other ip?

exactly

oh wait, also you need to flush privileges, in HeidiSQL: Tools > Flush > Privileges

<3 woot! Thank you to all who helped =) seeing as how i am a total nub at this stuff ill probably be posting again >.< But thanks !!

OK just a quick question since you guys probably know... when i enter in a custom item in query and run it.. then is there anything else i have to do after that to be abel to use the code in game to get the item?

Maybe Flush some more stuff? xD

Nothing in the mysql server, but you may have to reload the game server.