Skip navigation
Griffmon
Griffmon Calculating status...
Currently Being Moderated

MySQL Connection error

Aug 4, 2012 9:51 AM

Tags: #cs3 #mysql #connection #dreamweaver_cs3 #mysql_error

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!

613 Views   8 Replies   Latest reply: MurraySummers, Aug 4, 2012 11:21 AM
 
Replies
  • MurraySummers
    Currently Being Moderated
    1. MurraySummers,
    Aug 4, 2012 10:00 AM   in reply to Griffmon
    Report

    Do you have MySQL installed on localhost?

     
    |
    Mark as:
  • Griffmon
    Currently Being Moderated
    2. Griffmon,
    Aug 4, 2012 10:20 AM   in reply to MurraySummers
    Report

    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.

     
    |
    Mark as:
  • MurraySummers
    Currently Being Moderated
    3. MurraySummers,
    Aug 4, 2012 10:24 AM   in reply to Griffmon
    Report

    Localhost not your remote server.  You say you are using localhost for the MySQL server, so I am asking if you have installed MySQL on localhost.

     
    |
    Mark as:
  • Griffmon
    Currently Being Moderated
    4. Griffmon,
    Aug 4, 2012 10:35 AM   in reply to MurraySummers
    Report

    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?

     
    |
    Mark as:
  • MurraySummers
    Currently Being Moderated
    5. MurraySummers,
    Aug 4, 2012 10:57 AM   in reply to Griffmon
    Report

    This can be a bit tricky.  How did you install PHP - did you use MAMP or WAMP?

     
    |
    Mark as:
  • Nancy O.
    Currently Being Moderated
    6. Nancy O.,
    Aug 4, 2012 11:03 AM   in reply to Griffmon
    Report

    Setting up a PHP environment in Dreamweaver

    http://www.adobe.com/devnet/dreamweaver/articles/setup_php.html

     

    Building your first dynamic website – Part 1: Setting up your site and database connection

    http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt 1.html

     

     

    Nancy O.

     
    |
    Mark as:
  • Griffmon
    Currently Being Moderated
    7. Griffmon,
    Aug 4, 2012 11:12 AM   in reply to MurraySummers
    Report

    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:

    Apache version2.2.22
    PHP version5.2.17
    MySQL version5.5.23-55
    Architecturex86_64
    Operating systemlinux
     
    |
    Mark as:
  • MurraySummers
    Currently Being Moderated
    8. MurraySummers,
    Aug 4, 2012 11:21 AM   in reply to Griffmon
    Report

    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.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points