After setting up a MySQL user’s account and after Setting up the PHP / MySQL Site Definition in Dreamweaver now we are going to have a look at the process to create a MySQL database connection with Dreamweaver. After finishing the defining part you should approach the following MySQL connection dialog box in Dreamweaver.

Connection Name: choose your desired name
MySQL Server:
User Name: Your Username (i.e. Admin)
Password: *********
Database: Here you can directly enter the name of your database or select it from the list displayed of MySQL databases that currently exist on the server.

Note: It’s necessary for the MySQL Server field to enter localhost if PHP and MySQL are running on the same machine.