connecting to a mysql server running on https from netbeans running on windows

throne

• October 06, 2015 09:25

hello everyone, i have no idea on how to remotely connect to a mysql database backed-up on the cpanel on a https from my netbeans IDE running on windows. i have tried the steps written but i still have problem. i am void of understanding, i'm in need of dear help. thanks

• 

  cPanelMichael

  • October 06, 2015 15:29

  Hello :) Are you attempting to connect to a MySQL database that's hosted on the cPanel server? If so, simply add the IP address that you want to connect remotely via "cPanel >> Databases >> Remote MySQL":

  0
• 

  throne

  • October 06, 2015 20:08

  Hello :) Are you attempting to connect to a MySQL database that's hosted on the cPanel server? If so, simply add the IP address that you want to connect remotely via "cPanel >> Databases >> Remote MySQL":

  0
• 

  cPanelMichael

  • October 06, 2015 20:15

  You are logged in via Web Host Manager. The equivalent option in WHM is located at: "WHM Home " SQL Services " Additional MySQL Access Hosts" Thank you.

  0
• 

  throne

  • October 06, 2015 21:50

  You are logged in via Web Host Manager. The equivalent option in WHM is located at: "WHM Home " SQL Services " Additional MySQL Access Hosts" Thank you.

  
  Thanks Thank you! i was able to add my ip address in the box. but each time i try accessing the database from netbeans is flags an error. i have tried different parameters of hostname,port using the same username and password of the cpanel account but still to no avail. i dont know if you may be able to help with that as well. attached is a screen shot. thanks

  0
• 

  throne

  • October 07, 2015 12:01

  Thanks Thank you! i was able to add my ip address in the box. but each time i try accessing the database from netbeans is flags an error. i have tried different parameters of hostname,port using the same username and password of the cpanel account but still to no avail. i dont know if you may be able to help with that as well. attached is a screen shot. thanks

  
  i have another piece of information but don't know if its gonna be useful anyway. the mysql is hosted as localhost on the cpanel.still having issues connecting. thanks

  0
• 

  cPanelMichael

  • October 07, 2015 12:06

  You need to access MySQL over port 3306, not over the WHM port of 2087. Also, ideally you should login as the database username, and ensure that database username is added to the database via the "MySQL Databases" option within cPanel of the account. Thank you.

  0
• 

  throne

  • October 07, 2015 13:14

  okay...

  You need to access MySQL over port 3306, not over the WHM port of 2087. Also, ideally you should login as the database username, and ensure that database username is added to the database via the "MySQL Databases" option within cPanel of the account. Thank you.

  
  Thanks for your effort. i have created the user and password on the database. i have searched the MYSQL Databases uption within the cpanel of the account but cant find. i am logged in as WHM.

  0
• 

  cPanelMichael

  • October 07, 2015 13:47

  You have to login to to cPanel, not Web Host Manager. Browse to "List Accounts" in Web Host Manager and click on the cPanel icon next to the account to access cPanel. Thank you.

  0
• 

  throne

  • October 07, 2015 19:22

  You have to login to to cPanel, not Web Host Manager. Browse to "List Accounts" in Web Host Manager and click on the cPanel icon next to the account to access cPanel. Thank you.

  
  it seems there was no user created on the database! thanks.i have now created a user, gave it a password and granted all privileges to it. you have really helped me far but when i try connecting the netbeans using the newly created credentials i still get the same error as the previous. is there something else i am doing wrong?? thanks

  0
• 

  throne

  • October 07, 2015 19:25

  it seems there was no user created on the database! thanks.i have now created a user, gave it a password and granted all privileges to it. you have really helped me far but when i try connecting the netbeans using the newly created credentials i still get the same error as the previous. is there something else i am doing wrong?? thanks

  
  IT HAS WORKED BROTHER!!!! IT HAS WORKED!!!! i removed the https:// in the host name. thanks. you are the best

  0
• 

  cPanelMichael

  • October 08, 2015 12:55

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

  0
• 

  boomers07

  • November 17, 2015 04:30

  i also have same problem. how to solve it. help me

  0
• 

  cPanelMichael

  • November 18, 2015 17:53

  New i also have same problem. how to solve it. help me

  
  Is port 3306 open in your server's firewall rules? Thank you.

  0

Please sign in to leave a comment.