sklead
04-02-2019, 11:11 PM
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.
https://imgur.com/a/cG2q1mn
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
https://imgur.com/a/Xr3226a
- Click Port > TCP & Specific local ports. Enter 3306 and click Next
https://imgur.com/a/FsTbCko
- 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
https://imgur.com/a/VLan1yv
- 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!
https://imgur.com/a/hCouK6o
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
https://imgur.com/a/pv0YIok
- 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.
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.
https://imgur.com/a/cG2q1mn
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
https://imgur.com/a/Xr3226a
- Click Port > TCP & Specific local ports. Enter 3306 and click Next
https://imgur.com/a/FsTbCko
- 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
https://imgur.com/a/VLan1yv
- 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!
https://imgur.com/a/hCouK6o
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
https://imgur.com/a/pv0YIok
- 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.