[Help] Requesting help for remote access with navicat

[Sabens]

Hey guys,

I am trying to start up my own server, but I have a friend who has everything compiled, and needs DB access. I have followed all the guides on MMowned to making a server public, but whenever my friend tries to login, he can't connect.

When setting up mySQL, I set it so that remote machines can connect to the DB.

I have my dnydns name to empirewow.servegame.com. I have all the necessary ports forwarded on my router(3036,80,3306,3724,6112,6999,8050,8093,8129)

I opened up my C:\windows\sys32\drivers\etc\hosts file, and put in the following:
127.0.0.1 wowempire.servegame.org
192.168.0.1 wowempire.servegame.org
24.47.38.155 wowempire.servegame.org

Edit: Just to let you know, I can connect to the DB when the host IP is set to localhost.

I really don't know what is wrong. Anything will help at this point, I am up for any solution!

[Nilrac]

Post your conf files so I can look at them

[Sabens]

Config files are as follows:

World:

<WorldDatabase Hostname = "wowempire.servegame.org" Username = "root" Password = "hiddenfrompublic" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "wowempire.servegame.org" Username = "root" Password = "hiddenfrompublic" Name = "world" Port = "3306" Type = "1">

Realms:

<LogonServer Address = "127.0.0.1"
             Port = "8093"
             Name = "Default Logon"
             RealmCount = "1">

<Realm1 Name = "WoW Empire"
        Address = "wowempire.servegame.org:8129"
        Icon = "PVP"
        Population = "1.0"
        TimeZone = "1">

logonserver:

<LogonDatabase Hostname = "wowempire.servegame.org"
               Username = "root"
               Password = "hiddenfrompublic"
               Name     = "logon"
               Port     = "3306"
               Type     = "1">

[RedFox4]

not sure if this is what u mean or want but... have u tried adding another username that your friend could use to connect to the database? and/or have u tried port forwarding? (your router might be blocking him cuz routers suck like that)

[Sabens]

Yes, I did port forward and yes, I made a username for him. But yet, it still remains uncooperative .

[Sabens]

Here is a pic of my router's ports: portforwarding.jpg - Image - Photobucket - Video and Image Hosting

[Kiev]

Change your World.conf to

<WorldDatabase Hostname = "192.168.0.2" Username = "root" Password = "hiddenfrompublic" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "192.168.0.2" Username = "root" Password = "hiddenfrompublic" Name = "logon" Port = "3306" Type = "1">

And logon.conf to

<LogonDatabase Hostname = "192.168.0.2"
               Username = "root"
               Password = "hiddenfrompublic"
               Name     = "logon"
               Port     = "3306"
               Type     = "1">

and Realm.conf to

<LogonServer Address = "wowempire.servegame.org"
             Port = "8093"
             Name = "Default Logon"
             RealmCount = "1">

This should work.

[Sabens]

The problem is that when he tries to connect to my DB using navicat, he gets an error that says cannot connect, as if my DB doesn't exist.

[Kiev]

Can he get on ur server?

[Sabens]

I think the problem is port forwarding. Here is what I did: portforwarding.jpg - Image - Photobucket - Video and Image Hosting
, made the wowprivserver things, does anyone see something wrong with that?

[C.C.]

I seted up my MYSQL without remote machines and my friends could STILL acces it. DOn't forgot to open ports on your firewall or turn it off.

[Sabens]

Yeah, my firewall is completly off, but yet he still can't connect. Does anyone else have a DI-604 router? I think I'm port forwarding right, but I'm not sure.