View source

<div align=justify>First you have to make sure that the needed database is '''''[http://myidealhost.com/tutorials/How_to_create_database created]''''' under your [http://myidealhost.com/hosting.shtml web hosting account] and have a '''[http://myidealhost.com/tutorials/How_to_add_database_user privileged user added]''''' to it. Then check whether your IP address is allowed to access your MySQL databases '''''[http://myidealhost.com/tutorials/Remote_MySQL remotely]'''''.

'''Note:''' your IP address can be obtained from http://www.whatismyipaddress.com/ or http://www.query-ip.com

* Once your database is created, you should connect to the remote server where your website and database are located. This will allow you to continue with setting the MySQL database connection.

* Open up '''Database''' property window by select '''Window => Database'''

* Click on "+" sign and choose '''MySQL Connection'''. You will get a new window, where you should enter the following: '''MySQL username, password, database and MySQL server'''.

* Type the connection name in the first field. In the '''"MySQL server"''' field type '''localhost'''. Then enter the MySQL logins (i.e. username and password) and the database name. Click '''OK''' to connect to the database.

If all details are entered correctly, you should be able to see your connection listed in the '''Databases''' tab.</div>

Return to How to connect to MySQL database with Dreamweaver.

Retrieved from "http://myidealhost.com/tutorials/How_to_connect_to_MySQL_database_with_Dreamweaver"

Navigation

Search