Unable to access MySQL database

[Guest]

I recently set up a MySQL database and have been unable to access it using Dreamweaver CS4.  I already tried my hosting site's support section and they confirmed that they have allowed access to my database via another management tool, i.e. Dreamweaver, and that all the information is correct.

My Database name is: jazzothegreat

I have a username and password (which I'm not sharing for security purposes)

And my Database server address is 204.12.14.92.

What should I put in which field to make it work?

Also, I do not have a PHP/MySQL testing server on my computer.  I want to do it all on my online server.

Thanks in advance,

Julian

[David_Powers]

Set up your the testing server in you Dreamweaver site definition so that Host directory points to the site root on your remote server, and URL prefix points to the URL address of your remote site. When creating the MySQL connection in Dreamweaver, set the value of server to the IP address you have been given. Make sure that Preview in Browser in the Preferences panel does not use the option to preview using temporary files.

[Guest]

I'm sorry, but I'm a little confused.  I didn't create a new Dreamweaver "site," I just have the one that is on the same hosting account as my website, but they are on different servers.  Could you give me a more step-by-step method?  (Sorry, I'm new to this)

Julian

[David_Powers]

Jazzo the Great wrote:

I'm sorry, but I'm a little confused.  I didn't create a new Dreamweaver "site,"

If you didn't define your site in Dreamweaver, you won't be able to do anything. Dreamweaver is a site-based application. See the help files for further details: http://help.adobe.com/en_US/Dreamweaver/10.0_Using/WScbb6b82af5544594822510a94ae8d65-7f63a.html.

Basically, the way you work with Dreamweaver is by replicating your live site on your local computer. When you have made the necessary changes, you upload the files to the remote server. The most common way to develop websites that use a MySQL database is to create test database on your local computer. However, Dreamweaver does let you use the live database on your remote website. To do so, you still need to set up a site definition on your local computer, and copies of all the web pages and associated scripts need to be on your local computer, as well. The only difference is in the settings for the Testing server within the site definition.

The following tutorial describes how to set up a local testing environment for PHP/MySQL: http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php.html. The fifth page of the tutorial (http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php_05.html) describes the site definition process. If you want to use your remote server for testing, select FTP instead of Local/Network as the value for Access. Then fill in your FTP details. The Host directory field should contain the path you normally enter to upload files to your remote site. The URL prefix field should contain the base URL of your site, for example: http://www.example.com/.

When you test your pages, Dreamweaver uploads the page to the remote site for processing, and connects to the remote database if necessary.

This is generall considered to be less convenient and a less secure way to develop a PHP/MySQL website, but the option is there to do it that way if you want to.