Solved

Connect Dreamweaver to MySQL hosted by GoDaddy

Posted on 2009-03-29
11
2,240 Views
Last Modified: 2012-05-06
Hi Experts, this one is over my head and Godaddy is no help at all. But hopefully someone has luck with this before. I have created a MySQL database on godaddy with direct remote connection enabled. I am using dreamweaver cs3 and trying to connedt to that database without luck. I continue to receive an error "HTTP error code 403 Forbidden"

I am new to the mysql stuff so not sure where the problem lies. I
In dreamweaver I have added the correct MySQL server, username, password, database name.

I have searched the web and many have complained about godaddy not helpfull in this matter, but I know it has been done, but I am to new and cannot understand where I am going wrong. Please can some guide me in getting this right?
0
Comment
Question by:nkengie81
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 3

Expert Comment

by:techmaza
ID: 24013794
i have not used godaddy for website hosting but i have used other similar web hosting provider like brinkster.com and other i have not faced such problem but i think the problem is with ur syntax or server configuration to allow sql queries to fire....

i think u must provide code written in dreamweaver so that we can figureout the problem
 
0
 
LVL 10

Expert Comment

by:Kechka
ID: 24013847
I think that you won't be able to connect.

selected from link below
HOSTING CAVEAT: The following hosting companies are not DreamWeaver friendly-

    * Godaddy.com hosting - don't even try it. They do not allow a MySQL connection with Dreamweaver

http://www.nebulex.com/index.php?option=com_content&view=article&id=6&Itemid=62

and from adobe newsgroups

I found that DW's PHP/MySQL behaviours are not available using GoDaddy
as a host.

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=189&threadid=1344073&enterthread=y
0
 

Author Comment

by:nkengie81
ID: 24014151
I have seen that information before, but I also found that it is possible with godaddy, but it was a pain and I don't have the expertize to meake it work.

Techmaza, where in dreamweaver would I find the coding so that I can post here? Remember, I am new to this stuff.
0
 

Author Comment

by:nkengie81
ID: 24014734
This is the script that I am using in my DatabaseConnection.php file. I got this information from Godaddy. I am not sure what goes in the 'your_field' section. Do I need to list all the fields in my database here?
<?php

//Connect To Database

$hostname='jondoe.db.4149523.hostedresource.com';

$username='jondoe';

$password='password1';

$dbname='test';

$usertable='members';

$yourfield = 'your_field';
 

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');

mysql_select_db($dbname);
 

$query = 'SELECT * FROM $usertable';

$result = mysql_query($query);

if($result) {

    while($row = mysql_fetch_array($result)){

        $name = $row['$yourfield'];

        echo 'Name: '.$name;

    }

}

?> 

Open in new window

0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 250 total points
ID: 24015272
What is your testing server set to?  It should exactly mimic the remote server settings...
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:nkengie81
ID: 24018715
Jason: I am not at my computer right now, but I will take a look at that. That can possibly be my problem. At first I wasn't using a testing server (at least I don't think so). I then download MySQL last night for use as my testing server. You asked "what is my testing server set to" Is there something specific it needs to be. I probally don't understand it all, but learning as I go.

I have install MySQL Query Browser and was able to connect to MYSQL database without problems, so I know it has to be something I am doing wrong in dreamweaver.

Thanks
0
 
LVL 3

Expert Comment

by:techmaza
ID: 24029193
It is correct PHP code to connect to database In PHP to connect with database and fetch the result

       First of all check whether connection is ok i.e, whether 'Unable to connect to database! Please try again later.' error is coming or not if this error is coming then u have to check username, password or hostname and if this message is not coming then check whether database "test" is present or not with table name 'members' and table field  'your_field'  thru phpMyadmin since database is in MySQL.




0
 
LVL 3

Assisted Solution

by:techmaza
techmaza earned 250 total points
ID: 24029244
 The problem may be with Testing server what ur Using to test locally if u r testing locally with database residing in ur own server then u have to change connection parameters.

 I suggest to test ur website locally by installing WAMP or LAMP according to ur OS and then u have to just change connection parameters i.e hostname,username and password to connect with godaddy server.

0
 

Author Comment

by:nkengie81
ID: 24030911
I can connect to the test server without problems. I can upload my webpages the remote server. But not the MySQL database. If the test server works ok, is there certain files that I need to transfer to godday for me to connect?
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24030920
Did you try what I suggested (set the testing and remote servers to be the same thing)?
0
 

Author Closing Comment

by:nkengie81
ID: 31564082
Thank you guys, I guess I didn't quiet understand the testing server function. I installed the WAMPP, got that running correctly, then made certain that username, database name, server name and password was all the same. Thanks again for pointing me in the right direction. Working on login form, reset, and stuff like that, so sure to back with new questions soon. LOL For those that say that Godaddy won't work, I am living proof that it can.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now