How can I connect to a MySQL database from Dreamweaver?

To connect to a MySQL database from Dreamweaver follow the below steps:

Login to your cPanel account at www.yourdomain.com/cpanel.’ Click on 'MySQL Databases' under the 'Databases' menu.’ Add a new user’ by entering a username’ and password if you don't have one you would like to use. Add the 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.’ 

Ensure your site’ is setup for’ php/mysql in Dreamweaver, you can use our Dreamweaver Video Tutorials to make sure it is setup correctly. Dreamweaver 2004, Dreamweaver 8 and Dreamweaver MX.

You now need to connect to your account and set up a connection to’ the 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’ 

Then’ test the connection to see if your settings are correct.

  • 25 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:-’ Login to your control panel...

I would like to dump the Table Structure for my MySQL Database, but none of the data.

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...

I can't log into MySQL from a remote computer using a MySQL admin tool.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such...

What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database:’ Locally -’ from a script on the...

How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...