I search for some of the previous topics and I couldn't find any answers. I need help.

I'm a beginner at website design and I'm attempting to include a DB with my site. When I go to DB connections, how do I find MySQL IP address? also what do I place in "Database"?? Please help!!

Thanks,
CH

First, where is your site in your local computer or in a remote server. I don't have much experience with mySql but what I have learnt is that some webhosts provide the means to create a database. They give you the server address, then when you create your database you'll assign a name, then you will also have your username and password. Later that information is used to open a connection from DW.
Open a blank page(php) and create your connection. It is pretty straight forward. However, creating your DB may need more research and study of mySQL. But there are many tutorials out there.

Good luck.

Hi
First off if you are developing and designing you will need to create a local version of you database to allow dw to build the queries you are going to use on the server.
I recommend that you install a local webserver and mysql database server- you can download the exes from the respective websites to do this - apache, php, mysql etc or indeed iis off the windows disks. Alternatively download a pre comiled package all ready to go- I use www.devside.net.If you have aspare machine you can use it as a local testing server.
Regarding your connections though its best to use your own machine - I will explain why.
Most hosting companies (not all) in my experience, use the same server to host the webserver as hosts the database server, so your connection details in your connection file will point to "localhost".. If you use the same setup locally on your development test machine- everything just transfers over.. If you don't use your own machine as a development server, but use a local test server- a spare pc for example, your connection needs to point to its ip address. When you upload to your host you will need to modify your connection nfo for your remote connection to match their host name.

Finally one other thing to remember when you create your database user that will be used to login to your database, use a unique username (not root) and when you set the password remember to set the PASSWORD parameter- as mysql needs the password in this format to take a connection- otherwise you will keep getting errors. if your password was "letmein" in the sql to enter your user details use PASSWORD 'letmein'. This encrypts it in the correct format.

HTH

-----------------------------------
www.halleynet.co.uk