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

Error! Need help... :(

User, date Message
Written by Taken
6 years ago
Category: Creating a connection
8 posts since Thu, 12 Feb 09
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

:(
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07

wrote: 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)
Written by Taken
6 years ago
8 posts since Thu, 12 Feb 09

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



Where can i enter this code?
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07

wrote: Where can i enter this code?



Query pane.
Written by Taken
6 years ago
8 posts since Thu, 12 Feb 09
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
Written by ansgar
6 years ago
5022 posts since Fri, 07 Apr 06
... of course you pressed F9 or the blue "Play" button to execute the SQL did you?
Written by Taken
6 years ago
8 posts since Thu, 12 Feb 09

wrote: 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
Written by ansgar
6 years ago
5022 posts since Fri, 07 Apr 06
Ok, try this instead:

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

Written by Taken
6 years ago
8 posts since Thu, 12 Feb 09
OK i tryed that.. something happend, i did not get an error.. now should i try to log on with my other ip?
Written by ansgar
6 years ago
5022 posts since Fri, 07 Apr 06
exactly
Written by ansgar
6 years ago
5022 posts since Fri, 07 Apr 06
oh wait, also you need to flush privileges, in HeidiSQL: Tools > Flush > Privileges
Written by Taken
6 years ago
8 posts since Thu, 12 Feb 09
<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 !!
Written by Taken
6 years ago
8 posts since Thu, 12 Feb 09
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
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07
Nothing in the mysql server, but you may have to reload the game server.
 

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