Printable View
Hmm it's wierd everythings runs fine when i use Localhost. But when i add Lan/Wan ip i keep getting this error ("World Database: 192.168.x.xxx;3306;root;root;mangos
ERROR:Could not connect to MySQL database at 192.168.x.xxx: Host 'Acer' is not allowed to connect to this MySQL server
ERROR:Cannot connect to world database 192.168.0.4;3306;root;root;mangos") Help THanks:) and i dont know how to grant access to that Acer thingy XD
If you are trying to get it where people outside your network can join. IE a WAN. 192.168 is not the address you want to use. That is private. Try whatismyip.org
Quote:
Originally Posted by andy007
What do you need to change the sql database address for. . Are you moving the sql server >?
I use localhost on my linux server and it runs just fiine with that setting .. Allows people to connect to the server LAN and WAN with out issues.
Another thing you might want to check is the permissions to the sql DB
if you want to allow access to a Dynamic IP then you might want to change the permissions int he db to
Grant Privileges on mangos to 'root'@'%' Forgot the entire syntax but you get the jest of what you might look into.
hmm i dont know wher the acer come from but when i use 192.168.x.xxx IP it shows Acer:/
Forgot to say its the same when i use Wan ip too it do the same..?
EDIT i forgot to say i use Router :/
Now i used WAN ip: World Database: 80.166.164.231;3306;root;root;mangos
ERROR:Could not connect to MySQL database at 80.166.164.231: Host '0x50a6a4e7.naenxx7.adsl-dhcp.tele.dk' is not allowed to connect to this MySQL server
ERROR:Cannot connect to world database 80.166.164.231;3306;root;root;mangos
dude whta are you doing ;o) never set 80.166.164.231 leave it like this 127.0.0.1
OMG .. i didnt know :/ then how to get ppl to join my server? please :)
go to your mangos table en set there you no-ip , ip for example if your now ip is g-s.no-ip.biz set that in your realm table in the addres btw dont forget to use that no ip update tool , if youdont have that ask me later :o)
i'm gonna install totale new mangos server so i'm here to help ,( only whit things i now :o) )
Hehe. What you mean with Mangos table? in Navicat? i maked a No-IP..
wow1st.no-ip.info that was from 80.166.164.231 IP (WAN)
Com'on :( Answar i want the server up, you are my destiny or my server's
-||-
Sry! :/ didnt see you allready writed Realm tabel lol:( hmm update tool???