I am using DW CS3 and no matter what I do when tyring to connect to a MySQL databsed I get "an unidentified error has occured" when I click on the "Select" button. I am using "localhost" for the MySQL server and definintely using the correct User name and password for my web hosting account (Hostgator). Has anyone else ever had this problem or have any suggestions?? You help is appreciated!
I do not see any way or options for doing that on my CPanel. Is that a normal step with most web hosting companies? If so, what should I be looking for to complete the task? I am pretty novice at this. Thanks for yourassitance.
I don't think I have. I am not sure how to do that. I did export the database.sql file, but I don't know where to put it on my local machine. Do I need to add a localhost directory in my site root and put the file in there?
Setting up a PHP environment in Dreamweaver
Building your first dynamic website – Part 1: Setting up your site and database connection
Like I said I am very green. I have been researching inbetween our conversation and I am learning that I have missed a couple of major steps. I have not loaded PHP yet and am about to do so. Would you recommend MAMP or WAMP over the otherone. I am working off Windows 7, and my web hoster has the following charaterisics:
If you are on Windows, then WAMP is the choice - it will install PHP, as well as MySQL.
Now, you *CAN* use the remote host as your MySQL server, but the problem there is that when you are testing locally, you would use the IP address of the remote server, but when you go live, you have to change that to 'localhost'.
Normally what you do is to install MySQL locally, develop locally, and when you go live you just dump your database from the local MySQL and load it on the remote host. That way, 'localhost' works in both places.