Create a MySQL database connection in Dreamweaver

Create a MySQL database connection in Dreamweaver

Creating your database connection in Dreamweaver is the final step in preparing your system for dynamic web development. Once this has been defined, you are ready to start producing your dynamic website. A PHP database connection tells Dreamweaver, that the current site is going to create PHP pages, and refer to a specific database to store or display data.

This tutorial shows you how to set up a PHP database connection from within Dreamweaver that you can then use in your site.The Databases panel allows you to define your database connections for your site. This even gives you the opportunity to preview some of the data in your database once a connection is established.

From the Dreamwaever Window menu, select Databases.
The Databases Panel should now be open.

NOTE: If the window doesn't appear, it is most likely tucked away in the tool panels along the right-hand side of Dreamweaver

2. Connect to your database
Once the databases window is accessible, it's time to make a new connection.

Video Tutorial: If you are creating your database connection to your live (hosting provider's) server. Watch this video on how you can obtain the correct settings.
In the database dialog, click the Add (+) option, then choose MySQL Connection.

The MySQL Connection window will display.
In the Connection field, enter your connection name.
For this tutorial we will call our connection "mysql_tutorial", but the connection name can be whatever you like. Try to keep it descriptive of the database being connected to, as several connections can get confusing to work with.
In the MySQL server field, enter the name of your MySQL Server.
The MySQL server is the name of the server that hosts MySQL. In most cases, it will be hosted on the same server as your site, and in that case you can enter localhost as the server name.
In the User name field, enter your user name and password.
User name is the name set up for the specific MySQL server you are connecting to, and Password is the password you defined when creating your database.

NOTE:If you don't remember creating a password, you probably weren't asked to do so when setting up your testing server or database. You can leave this field blank, but should go and specify a password for your database later. For testing servers, your User name is probably 'root' as this is the default "SuperUser" for MySQL databases.

In the Database field, enter your database or click Select to choose it from a list.
You can manually input the database here (including .sql), or click Select, to see a list of databases hosted on the MySQL server.

buy adobe dreamweaver cs6 mac pc only at $ 50

 Want buy adobe photoshop cs6 at cheap price? you can go to my webshop to buy it ,cheap dreamweaver cs6  full version .

  It is not a OEM or tryout version.

  We offer worldwide shippment .

  You can pay by paypal.

you can buy it at my website shop at only $50 low price cheap dreamweaver cs6 pc mac version and more other usefull design software tools.

 cheap adobe dreamweaver cs6 $50