MySQL Database

How to connect to your MySQL database

Open Dreamweaver. There are few steps before setup the connection to your database. First you have to create such a database and to add privileged user to it from your cPanel -> MySQL Databases. After you create it, you have to allow your IP address to have rights to access your MySQL databases. You can see your IP address at:

http://www.whatismyipaddress.com/

Type that IP address in the field placed in the Host Allowed category on the bottom of cPanel->MySQL Databases tab.

Also you have to have established site connection to your web site stored on the remote server where databases are located too. See "Establish connection with remote server and upload files" tutorial.

After you have done this simple preparation steps you can continue with setting your connection to MySQL database.

Select Window -> Database to open up Database property window:

Click on "+" sign and choose MySQL Connection option. The following window will appear where you can enter to which database to connect and privileged user details of it.

In first field type your connection name, it can be any name of your choice but only letters without any spaces. In the "MySQL server" field please type "localhost". Then enter MySQL username and password details and the database name as shown in the example. When you setup your connection click the "OK" button.

You should see your connection listed in Database property window if everything worked as it should be: