Hello. Thanks for visiting. Chat representative
Have questions about Midphase? I'm here to help.
*required Start Chat

How can I connect to our MySQL database from Dream Weaver?

This article contains information about connecting to your database from Dreamweaver.

Log into your cpanel account and click on "MySQL Databases" then under "Users" create a new user and password if you don't already have one you want to use. Then add that user to the database you wish to work with through Dreamweaver.

At the bottom, add the “%” symbol to the “Add Host” listing, this is a wildcard and will allow connection from any computer if they have the correct user name and password.

Now in dreamweaver make sure your Site is setup for php/mysql you can use our tutorials to make sure it is setup correctly.

Now to connect to your account and set up a connection to a database.

Up at the top menu bar in Dreamweaver click on “Window” then “Databases”. This will bring up a menu on the side bar, if it is not already up, where you can click on the + button and set up a “MySQL Connection”. Label it what you would like in the “Connection Name” and use these settings:

MySQL Server = localhost
Username = The control panel username then “_” and MySQL database username
Example: cpanel_mysqlname
Password = Password to the MySQL database username
Database = Click “Select” and choose your database

Lastly, you'll want to test the connect to ensure your settings are correct.

For more information and tutorials, see Dreamweaver's Developer Center
For Dreamweaver troubleshooting/support, see Dreamweaver Help

Last Updated: 19th of February, 2013     Article ID: 584