Hello All,
I know there are many other posts that troubleshoot connection help when it comes to EOC as well as the wiki, but I still see a lot of posts that are asking for help. I'm hoping this helps others, as it's a process I go through any time I have issues connecting.
Step 1) Opening Ports
First, go to
https://www.canyouseeme.org/ and add your IP address and make sure "Port" is 3306. If you don't know your IP you can go to
https://www.whatismyip.com/ and use the IPv4 line.
If it doesn't say "Success" then port 3306 is closed!
To open your ports:
- Go to your firewall. In Windows 10 just click the Windows button in the bottom left and start typing
Windows Defender Firewall.
- Right click
Inbound Rules >
New Rule
- Click
Port > TCP & Specific local ports. Enter
3306 and click
Next
- Click
Allow the connection, click
Next
- On the next screen leave all 3 boxes checked, click
Next
- Name your rule anything you want
Now you need to open the port on your router.
- Go to your router page. This is usually
192.168.0.1 in your web browser
- It varies by the router, but find the
Firewall or
Ports page. Mine is under
Advanced and
Port Forwarding, yours may be similar
- Make sure the
Type is
TCP&UDP,
Start and
End Port is 3306
Now check
https://www.canyouseeme.org/. It should say Success now if it didn't before.
Step 2) Setting Up HeidiSQL
HeidiSQL comes with the server installation, but whatever database editing program you use is what you'll need to do the following steps in.
- Open HeidiSQL and click
Manage user authentication and privileges
- Click
Add
- Your
Username is whatever you want as well as the password. The
From Host can either be
% or
142.44.176.142. Using % will allow any connection whereas 142.44.176.142 will only allow EOC, therefore it is more secure, but either will work.
- Ensure you have
Global privileges checked!
Step 3) Connecting to EOC
- Go to
http://eoc.akkadius.com/EOC2/login.php
- Line 1 is YOUR IP address. You can use
https://www.whatismyip.com if you don't know.
- Line 2 is your database name, "peq" (no quotes) by default
- Line 3 is the username you setup in HeidiSQL in the previous step and Line 4 is the password
- Click
Verify connection
And you should be in! I tried breaking this down Barney style for people who may not be technologically inclined (as I am not either). Again, Akkadius laid it out well in his post about EOC and in the wiki, but hopefully this helped someone.