The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Remote Connection not working at all

Discussion in 'Database Discussions' started by nicolasFebrisur, Apr 14, 2016.

  1. nicolasFebrisur

    nicolasFebrisur Registered

    Joined:
    Apr 14, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Malaga
    cPanel Access Level:
    Website Owner
    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:
    • 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:

    upload_2016-4-14_10-20-35.png

    upload_2016-4-14_10-21-9.png
    Also, IP Blocker seems to be blocking all IPs:
    upload_2016-4-14_10-23-29.png
    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!
     
    #1 nicolasFebrisur, Apr 14, 2016
    Last edited by a moderator: Apr 14, 2016
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :),

    Is Mysql port 3306 is open on your server ? Please confirm this with your host provider.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
    nicolasFebrisur likes this.
  4. nicolasFebrisur

    nicolasFebrisur Registered

    Joined:
    Apr 14, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Malaga
    cPanel Access Level:
    Website Owner
    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 !
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page