 |  |  |  |  |  |  |  |
localhost to remote server
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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!
If anyone has experienced any difficulty in a similar situation I would really appreciate any advise that may help me with my problem. Thanks!
•
•
Join Date: Jun 2007
Posts: 1,227
Reputation: 
Solved Threads: 167
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.
•
•
Join Date: Sep 2007
Posts: 271
Reputation: 
Solved Threads: 16
Posting Whiz in Training
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
•
•
Join Date: Jun 2007
Posts: 1,227
Reputation:
Solved Threads: 167
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.
•
•
Join Date: Jun 2007
Posts: 1,227
Reputation:
Solved Threads: 167
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.
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.
|
Similar Threads
- Remote Desktop/Terminal Server - 'take over' session (Windows NT / 2000 / XP)
- What's better? Windows 2000 Server or Linux Server? (Windows Servers and IIS)
- "Forbidden / You don't have permission to access / on this server." error (Linux Servers and Apache)
- PHP, Dreamweaver and MySQL (PHP)
- connect one server from another server through script (PHP)
- Remote Database server error. (C#)
- Can't get samba to work! (*nix Software)
- another newbie with alot of redhat and apache server Q'S (Linux Servers and Apache)
- Colo Server Management & Data Centers (Networking Hardware Configuration)
Other Threads in the PHP Forum
- Previous Thread: Calculating age
- Next Thread: Populating an array with results from a mysql query...
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
# 5.2.10 alexa apache api array beginner binary broken cakephp checkbox class clean clients cms code cron curl database date directory display dissertation dynamic echo echo$_get[x]changingitintovariable... email encode error fairness file files folder form forms function functions google href htaccess html image images include indentedsubcategory insert ip javascript joomla legislation limit link local login mail memberships menu mlm multiple multipletables mysql mysqlquery newsletters oop open paypal pdf persist php problem provider query radio random recursion remote rss script search secure server sessions sms sockets source space spam sql syntax system table tutorial update upload url validator variable video web youtube
