Have a question you need answered? We're here to help.
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
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
Can't find the answer to your question? Chat live with a member of our technical support instantly!Chat Live Now
Email your question to a member of our technical support team.Email Support