help with sql connection on localhost

I'm trying to set up a MySQL Database connection in dreamweaver, to connect to
a Mysql Database on the same computer.
But when I go to select a database I get a 500 internal server error. I think
it must be how I set up my site, but i'm totaly stuck.

I set up the connection like this
Connection Name = MyDb
MySQL Server = localhost
User Name = root
Password = *********
Database = # That's the one I'm haveing trouble with.



The site is set up as follows:

Local Info

Local Root Folder = C:\Apache Group\Apache2\htdocs\site

Remote Info

Access = None

Testing Server

Server Model = PHP MySQL
Access = Local/Network
Testing Server Folder = C:\Apache Group\Apache2\htdocs\ # Which is the path to
localhost.

I'm running Apach2, have installed PHP, and MySQL.

swhxswt thanx in advance

You can make multiple databases with MySQL, if it can't figure out which to
pick, you will get an error. Ask your hosting provider to tell you the DB names
and/or make one. If you have telnet, you can probably use phpMyAdmin and create
one.

I`ve got some notes on troubleshooting MySQL connections at:

http://www.dreamweavermxsupport.com/index.php?type=article&pid=60&sid=61

Should help you to understand how the connection works, and how to solve any
problems


--
Gareth
http://www.garethdp.com/
Buzz inet - http://www.buzzinet.co.uk/

Team Macromedia Volunteer for Dreamweaver MX
Dreamweaver MX Support: http://www.dreamweavermxsupport.com/index.php

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
http://www.dreamweavermxsupport.com/extensions/

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox