N/APosted on - 09/26/2011
I am using XAMPP local host server in my computer.When I connect database with PHP code it works properly but when I try to connect it using Macromedia Dreamweaver 8 it does not work. An error message is displayed on screen. I have set every option necessary for the connection to Macromedia Dreamweaver.
Error connecting mySQL database to Dreamweaver
Before you connect your page, you must note down your database's information like MySQL server, username, password, dbname etc, and must have filed with PHP extensions.
After that open your PHP page in Dreamweaver; then in upper right panel, select Windows; then pick Database. It will show database panel. Next click on (+) icon and select MySQL Connection like this picture below.
Next Dreamweaver will show a box to insert your data connection, fill it with your DB data:
Connection Name: create a connection name;
MySQL Server: yourmysqldomain or localhost;
Username: your DBuser or root;
Password: MySQL password (usually blank);
Database: name of your database, or you can click Select to choose from MySQL databases's list in your XAMPP the server.
This is how to make a connection between your Database with Dreamweaver. Later you can make your DW connect to your website. You can use these links from Adobe Support, Lunarpages forum, Site5 forum, and Dreamhost forum to find more explanation about database connection in Dreamweaver 8.