Jump to content

Database on localhost and CP on webhost


Recommended Posts


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

Ok, nag-eerror kasi kapag ni-coconfigure ko ang ceres cp. Hindi ko alam kung paano ko i-allow permission yung webhost para ma-access PC ko. So far nka off naman lahat firewalls ko and ayaw parin mag-connect. Eto nga pala exact 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"

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  47
  • Topics Per Day:  0.01
  • Content Count:  633
  • Reputation:   78
  • Joined:  11/14/11
  • Last Seen:  

I think its a permission error.

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:  

Na-permit ko na siya on my PC side. Thanks for moving the topic.

Problem still persists.

Edited by evespiridion
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  439
  • Reputation:   29
  • Joined:  12/08/11
  • Last Seen:  

You just have to make sure na may permission ang IP ng web server na magamit local database mo. Also don't forget to port forward port 3306.

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:  

Port forwarded 3306 beforehand. So far, gumamit ako ng grant command sa mysql which is exactly like this..

grant all on *.* to 'my username'@'%' identified by 'my password'; so basically halos lahat dapat pwede na i-access yung database ko. But so far ayaw parin. I already commented out the bind-address line my.ini. I'm using MySQL Server 5.0.

So far hindi parin nagana.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  439
  • Reputation:   29
  • Joined:  12/08/11
  • Last Seen:  

I think yung bagong versions ng MySQL, d mo na kailangan ng bind-address.. Have you tried using newer versions?

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:  

Hindi pa eh. Mejo complicated kasi yung bagong version niya. Yung may workbench ba yun? Mas sanay ako dun sa may Query Browser :)

As of now nagbago yung error number nya, from 111 to 110. Sir magnetix if you won't mind. Bigay ko sayo ip add ko and try mo if you can connect to my database.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  439
  • Reputation:   29
  • Joined:  12/08/11
  • Last Seen:  

add mo nlng ako sa YM, and i'll try to see if mkakatulong ako.

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:  

Sige thanks. Wait I'll add you up..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...