Error! Need help... :(
| User, date | Message |
|---|---|
|
Written by Taken
4 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
4 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
4 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
4 years ago 127 posts since Wed, 24 Jan 07 |
wrote: Where can i enter this code? Query pane. |
|
Written by Taken
4 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
4 years ago 3977 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
4 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
4 years ago 3977 posts since Fri, 07 Apr 06 |
Ok, try this instead: UPDATE mysql.user SET Host='%' WHERE User='root' |
|
Written by Taken
4 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
4 years ago 3977 posts since Fri, 07 Apr 06 |
exactly |
|
Written by ansgar
4 years ago 3977 posts since Fri, 07 Apr 06 |
oh wait, also you need to flush privileges, in HeidiSQL: Tools > Flush > Privileges |
|
Written by Taken
4 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
4 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
4 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. |