Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Remote Connection not working at all

Discussion in 'Database Discussion' 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,834
    Likes Received:
    85
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :),

    Is Mysql port 3306 is open on your server ? Please confirm this with your host provider.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    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:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice