User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,555 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,553 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1374 | Replies: 6
Reply
Join Date: Oct 2007
Location: Chicago, IL
Posts: 8
Reputation: ztwalsh is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
ztwalsh ztwalsh is offline Offline
Newbie Poster

localhost to remote server

  #1  
Oct 16th, 2007
I am developing a website where users can ad entries to a database. I am using phpMyAdmin to create the database. It works perfectly on my local testing environment, but when I upload it to my remote server it doesn't. I have used my hosting company's (GoDaddy) version of phpMyAdmin to create a database of the same name as on my local environment, still no luck. I have used GoDaddy's provided code to connect to the Database, I haven't gotten that to work either.

If anyone has experienced any difficulty in a similar situation I would really appreciate any advise that may help me with my problem. Thanks!
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation: kkeith29 is on a distinguished road 
Rep Power: 3
Solved Threads: 72
kkeith29's Avatar
kkeith29 kkeith29 is online now Online
Practically a Master Poster

Re: localhost to remote server

  #2  
Oct 16th, 2007
so where exactly are you trying to connect to the godaddy mysql server from? i have had this problem before and solved it, but i guess i am not following what you said.
Last edited by kkeith29 : Oct 16th, 2007 at 5:52 pm.
Reply With Quote  
Join Date: Oct 2007
Location: Chicago, IL
Posts: 8
Reputation: ztwalsh is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
ztwalsh ztwalsh is offline Offline
Newbie Poster

Re: localhost to remote server

  #3  
Oct 17th, 2007
I am trying to connect from my GoDaddy remote server. I just can't seem to figure it out.
Reply With Quote  
Join Date: Sep 2007
Location: Budapest
Posts: 252
Reputation: fatihpiristine has a little shameless behaviour in the past 
Rep Power: 0
Solved Threads: 14
fatihpiristine's Avatar
fatihpiristine fatihpiristine is offline Offline
Posting Whiz in Training

Re: localhost to remote server

  #4  
Oct 17th, 2007
remote connection feature activated or not?? if not, you cannot access your database...
Last edited by fatihpiristine : Oct 17th, 2007 at 3:59 pm.
Do a favour, leave me alone
Reply With Quote  
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation: kkeith29 is on a distinguished road 
Rep Power: 3
Solved Threads: 72
kkeith29's Avatar
kkeith29 kkeith29 is online now Online
Practically a Master Poster

Re: localhost to remote server

  #5  
Oct 17th, 2007
godaddy is very picky on where you can access their mysql servers. they don't allow remote connections. you can only use them from their hosting plans. you need to find your host address and then everything will work. i will give instructions where to find this if you need me to.
Reply With Quote  
Join Date: Oct 2007
Location: Chicago, IL
Posts: 8
Reputation: ztwalsh is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
ztwalsh ztwalsh is offline Offline
Newbie Poster

Re: localhost to remote server

  #6  
Oct 17th, 2007
If you could give some instructions that would be very helpful. I really appreciate your advise.
Reply With Quote  
Join Date: Jun 2007
Location: Valley Center, Kansas
Posts: 643
Reputation: kkeith29 is on a distinguished road 
Rep Power: 3
Solved Threads: 72
kkeith29's Avatar
kkeith29 kkeith29 is online now Online
Practically a Master Poster

Re: localhost to remote server

  #7  
Oct 17th, 2007
Instructions:

1. Login to Godaddy.com
2. Click 'My Account'
3. Towards the middle of the page there is a 'My Products' box and click 'Hosting Account List'
4. Next to your hosting account click 'open' to open the control panel
5. On the control panel you should see a database link, click it.
6. Click the mysql database icon
7. Next you will see a list of databases created by you. On the far right there is a 'Action' column. Find the pencil next to the database you want to connect to and click it.
8. In there you will find the host name. this is what you put in the host spot of mysql_connect statement.
9. Also there is your username at the bottom of the text. put that in your username spot. you should know your password.
Last edited by kkeith29 : Oct 17th, 2007 at 8:01 pm.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb PHP Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the PHP Forum

All times are GMT -4. The time now is 5:29 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC