View Single Post
  #212  
Old 02-13-2019, 02:26 AM
sklead's Avatar
sklead
Sarnak
 
Join Date: Jul 2005
Posts: 38
Default

Quote:
Originally Posted by tako_EQ View Post
Pretty sure I have done everything needed to connect to eoc, but still getting the same 2 error messages when trying to log onto eoc

made a new user with a password, changed it from localhost to all, and has permissions for all database (and peq database)

added a rule in my firewall to allow port 3306 through

someone said something about fowarding a port on my router? but when i login to my router, i dont see any such option to do that.

if anyone could help it would be awesome, thanks a ton
When you go to your router page it's usually under the "Advanced" settings, sometimes under a subsection called "Port Forwarding". Some routers give you the option to only do UDP or TCP, some give the option to do both.

If you still can't find it you can download Simple Port Forwarding here and just select your router model and put in your username/password, then input the port you want to forward and it'll do it automatically.

Additionally, to check if your ports are actually open, you can check here

If you open port 3306 on your firewall and router and it still doesn't work, most likely your database permissions are wrong. Try running the command below, where "username" is the username you want and "password" is the password you want


Code:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password';
__________________
In my defens, God me defend
Reply With Quote