The port (3306) in Windows Firewall were likely tied to a different .exe location. Either way, it's typically best to just remove the rules and then implement them again. I've noticed for whatever reason (likely a corruption of Window$ DB), that this often helps regardless of the situation.

I say the above on the assumption that the computer you're attempting to get this working on is the same computer as EQEMU was working on before (somewhere up there you said "again" as Grumpy pointed out). And that said computer has the same static IP address it had before (because I further assume you're running at least a consumer grade "router"/NAT).

Then also, did you repeat the process of making a SQL account for the EoC/editor (assuming you aren't using root - which just isnt the best practice)?

I think I saw an ad like that on backpage ? hahaha :P

I will say... Maze_EQ helped me get my router settings fixed. :)

Thanks again ;)

Uleat:

TCP [::1]:51066 [::1]:3306 ESTABLISHED
TCP [::1]:51067 [::1]:3306 ESTABLISHED
TCP [::1]:51068 [::1]:3306 ESTABLISHED
TCP [::1]:51069 [::1]:3306 ESTABLISHED
TCP [::1]:51070 [::1]:3306 ESTABLISHED
TCP [::1]:51071 [::1]:3306 ESTABLISHED
TCP [::1]:51072 [::1]:3306 ESTABLISHED
TCP [::1]:51073 [::1]:3306 ESTABLISHED
TCP [::1]:51074 [::1]:3306 ESTABLISHED
TCP [::1]:51075 [::1]:3306 ESTABLISHED
TCP [::1]:51076 [::1]:3306 ESTABLISHED
TCP [::1]:51077 [::1]:3306 ESTABLISHED
TCP [::1]:51078 [::1]:3306 ESTABLISHED
TCP [::1]:51079 [::1]:3306 ESTABLISHED
TCP [::1]:51080 [::1]:3306 ESTABLISHED
TCP [::1]:51081 [::1]:3306 ESTABLISHED
TCP [::1]:51082 [::1]:3306 ESTABLISHED
TCP [::1]:51083 [::1]:3306 ESTABLISHED
TCP [::1]:51084 [::1]:3306 ESTABLISHED
TCP [::1]:51085 [::1]:3306 ESTABLISHED
TCP [::1]:51086 [::1]:3306 ESTABLISHED
TCP [::1]:51087 [::1]:3306 ESTABLISHED
TCP [::1]:51088 [::1]:3306 ESTABLISHED
TCP [::1]:51089 [::1]:3306 ESTABLISHED
TCP [::1]:51090 [::1]:3306 ESTABLISHED
TCP [::1]:51091 [::1]:3306 ESTABLISHED
TCP [::1]:51092 [::1]:3306 ESTABLISHED
TCP [::1]:51093 [::1]:3306 ESTABLISHED
TCP [::1]:51094 [::1]:3306 ESTABLISHED
TCP [::1]:51095 [::1]:3306 ESTABLISHED
TCP [::1]:51096 [::1]:3306 ESTABLISHED
TCP [::1]:51097 [::1]:3306 ESTABLISHED
TCP [::1]:51099 [::1]:3306 ESTABLISHED
TCP [::1]:51100 [::1]:3306 ESTABLISHED
TCP [::1]:51101 [::1]:3306 ESTABLISHED
TCP [::1]:51102 [::1]:3306 ESTABLISHED
TCP [::1]:51103 [::1]:3306 ESTABLISHED
TCP [::1]:51104 [::1]:3306 ESTABLISHED
TCP [::1]:51105 [::1]:3306 ESTABLISHED
TCP [::1]:51106 [::1]:3306 ESTABLISHED
TCP [::1]:51107 [::1]:3306 ESTABLISHED
TCP [::1]:51108 [::1]:3306 ESTABLISHED
TCP [::1]:51109 [::1]:3306 ESTABLISHED
TCP [::1]:51110 [::1]:3306 ESTABLISHED
TCP [::1]:51111 [::1]:3306 ESTABLISHED
TCP [::1]:51112 [::1]:3306 ESTABLISHED
TCP [::1]:51113 [::1]:3306 ESTABLISHED
TCP [::1]:51114 [::1]:3306 ESTABLISHED
TCP [::1]:51115 [::1]:3306 ESTABLISHED
TCP [::1]:51116 [::1]:3306 ESTABLISHED
TCP [::1]:51117 [::1]:3306 ESTABLISHED
TCP [::1]:51118 [::1]:3306 ESTABLISHED
TCP [::1]:51119 [::1]:3306 ESTABLISHED
TCP [::1]:51120 [::1]:3306 ESTABLISHED
TCP [::1]:51121 [::1]:3306 ESTABLISHED
TCP [::1]:51122 [::1]:3306 ESTABLISHED
TCP [::1]:51123 [::1]:3306 ESTABLISHED
TCP [::1]:51124 [::1]:3306 ESTABLISHED
TCP [::1]:51125 [::1]:3306 ESTABLISHED
TCP [::1]:51126 [::1]:3306 ESTABLISHED
TCP [::1]:51127 [::1]:3306 ESTABLISHED
TCP [::1]:51129 [::1]:3306 ESTABLISHED

Grumpy: Yes my ports where open before when I built a server from scratch. I got a new pc to use as a server so I decided to try the repack instead this time. I also got a new router but I copied my port forwarding exactly like my old one was. So really its an all new setup

ghanja: I am using the same pc that has the eqemu server on it yes. The ip address changed from my old set up when I got a new router I ran the script in MySQL to set up the new user instead of using root but I don't know how to test it so see if I did it correctly

That's definitely localhost...

And EoC requires an external connection?

so what are you suggesting?

I can't go beyond that because I don't use EoC.

Someone else may have more knowledge on this issue. All I would be doing is guessing at this point.

Did you grant privs to the user on a specific IP?

or did you wildcard?

What does http://www.yougetsignal.com/tools/open-ports/ say when you test 3306 to your external IP?

Take a screen capture of your port forward screen on your router.


Make sure the router firewall has pass-through on 3306.

Forward port 3389 to your server host and see if you can check ports on 3389, or simply RDP(Remote Desktop Protocol) to the machine from an outside device (Tablet, cell phone, etc)

If it is a Linux machine, forward port 22, and test SSH using your preferred client (putty for beginners)

Add a firewall exception for 3306, stop mysqld/mysql, telnet from a local machine to the server using port 3306 If this works, your server's firewall is not the issue for incoming connections.

I mean, troubleshooting a network based issue is difficult when you don't know the user's environment.

I did the grant all like in your code. I cannot log into my Heidi sql with my newly create user name and pw though. I took the screen shot of router settings but I cant seem to upload the pic here. its asking for a url... I did the port test and it says my port 3306 is open. I do have the firewall exceptions for 3306 in mysqld/MySQL... not sure what telnet is

edit:

I didn't do anything different but it is now working and logging in... thanks for the help but not sure what the fix was

Grab a free photobucket account, upload pics to there. Copy the url it provides and post that where needed.

Photobucket is junk, use GreenShot with IMGUR extension