Jump to content
  • 0

CP on webhost and Database on local PC


evespiridion

Question


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  51
  • Reputation:   0
  • Joined:  05/03/12
  • Last Seen:  

I know this is possible, I am using 000webhost.com as the host for the CP. Now I wanted to connect the CP to my home PC as the server is running on the PC together with the database. Now I am having this error.

"Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2003): Can't connect to MySQL server on '112.207.3.203' (111) in/home/a9943513/public_html/cp/install/install.php on line 49"

Been wondering could this be done?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   593
  • Joined:  10/26/11
  • Last Seen:  

Does 000webhost allow outgoing MySQL connections?

  1. make sure they do (if they do not, then this won't work)
  2. setup your router to forward incoming port 3306 to your computer's LAN IP (instructions on that website; just find your router in the list)
  3. double check your CP config and make sure you use your WAN IP (112.207.3.203)
    and make sure all your MySQL users/passwords are correct.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  51
  • Reputation:   0
  • Joined:  05/03/12
  • Last Seen:  

As far as I've heard, they do not allow remote connections on their mysql databases. But that isn't my problem as the database is on my PC. I just want to make ceres cp retrieve the information from my PC, for reading data, and making ceres cp write data (inserting).

Link to comment
Share on other sites

×
×
  • Create New...