MySQL Remote Connection not working at all

nicolasFebrisur

• April 14, 2016 03:24

Hi guys! Im working right now in a python program to easen my colleague job, It should connect remotely to the MySQL database of our E-commerce store and let him add products easily (Unlike Opencart does). Problem is, every time I try to connect, I get error 10061. Its driving me nuts, probably its a simple mistake, but I dont get to solve it. This is what I've been doing: -Created a dummy user, granted all permits via MySQL DataBases. -Added my static ip to Remote MySQL. -Tried to connect with these parameters: [LIST]

hostname: Taken from phpMyAdmin-> Variables-> hostname, looks like this: nsXXXXXX.ip-XXX-XXX-XXX.eu

username: Taken from the user I created, looks like: databaseName_UserName

database: Taken from the database, looks like: databaseName

pass: the password

port: 3306 All I get is Error 10061... What could be wrong? I cant white list my IP in cPanel, or at least I dont know how, this is my cPanel: Also, IP Blocker seems to be blocking all IPs: Ip Blocker only block, I dont find anyway to whitelist my IP in any kind of firewall. Well, I hope you guys can help me solve this mess! :D Cheers!

• 

  24x7server

  • April 14, 2016 11:46

  Hello :), Is Mysql port 3306 is open on your server ? Please confirm this with your host provider.

  0
• 

  cPanelMichael

  • April 14, 2016 21:31

  Hello :) You will need to report this to your web hosting provider, as it's possible they have restricted traffic to the MySQL port (3306) in the system firewall. Thank you.

  0
• 

  nicolasFebrisur

  • April 18, 2016 07:21

  Thanks guys for the fast response, I just asked my host to open the port, once I get it to work I will post about it :D !

  0
• 

  cPanelMichael

  • April 18, 2016 17:55

  I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.