Skip navigation
Currently Being Moderated

MySQL Not Saving

Apr 24, 2012 5:24 AM

Tags: #cs5 #dreamweaver

Hi

 

I have set up my testing server and is all working on a local machine, when i click + to set up a new MySQL Connect and enter all the fields and test the connect its say Connnection was made successfully but when i click ok it dont save it.?

 

Thanks

 
Replies
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 24, 2012 5:32 AM   in reply to Daniel Waddon

    Can you elaborate more on your issue please?

     
    |
    Mark as:
  • Sudarshan Thiagarajan
    4,000 posts
    Oct 15, 2010
    Currently Being Moderated
    Apr 26, 2012 7:52 AM   in reply to Daniel Waddon

    Here is the procedure you should ideally follow to setup a MySQL Connection on DW. Look through to see if you've missed our something. I'm posting screenshots for each step:

     

    1. First off, Site > New Site. Fill in your Local Info here. See below for example. I'm using MAMP on my system.

     

    Screen Shot 2012-04-26 at 7.36.37 PM.png

     

    2. Now, define your Testing Server - in my case I'm running PHP and MySQL on my localhost. Do note that I've specified localhost:8888 in URL Prefix as that's the port on which my MAMP installation executes. This may be different for you depending on your configuration. In default instances for MAMP/ LAMP/ WAMP its mostly 8888 for Apache and 8889 for MySQL. However, yours may be 80 for Apache and 3306 for MAMP (Default Web Ports). You need to check  your local environment for this. If you're testing other sites locally using localhost/sitename, then you'll not have a port number that follows. You could just leave it localhost/prefix-to-your-site-root-folder

    Screen Shot 2012-04-26 at 7.36.46 PM.png

    3. Now, you're ready to create a MySQL Connection. If your Databases tab doesn't show up, click on Window > Databases for it to show up. If your Database tab is greyed out, keep in mind that you need to first create a new page (PHP) for it to become active before you could create a new connection.

     

    Screen Shot 2012-04-26 at 7.37.00 PM.png

    4. Click the + icon and select MySQL Connection

     

    Screen Shot 2012-04-26 at 7.37.08 PM.png

    5. You'll see this window

    Screen Shot 2012-04-26 at 7.37.17 PM.png

    6. Define your MySQL Connection. In my case, as mentioned earlier, MySQL is running locally at root. So, MySQL server parameter is localhost. If you're connecting to a remote server, you need to specify the remote server's IP or domain name here with the username and password to gain access to your SQL databases. Make sure your username has access to the Database that you'd like to select or DW wont show up your desired DB. Once you fill in the information, click on Select next to Database parameter.

    Screen Shot 2012-04-26 at 7.37.37 PM.png

    7. Select Database dialog will show up. Choose the desired DB that you're going to use. If you haven't created one already, you need to create it using MySQL DB Wizard/ phpMyAdmin first for your DB to show up here. Keep in mind, DW will only let you choose a DB, not create one on your server.

    Screen Shot 2012-04-26 at 7.38.02 PM.png

    8. Once you choose the desired DB (in my case for testing purposes, I've chosen sqlcon, click Test

    Screen Shot 2012-04-26 at 7.38.10 PM.png

     

    9. You'll see this dialog box once DW successfully connects to your DB. This may take a little longer if you're choosing a remote DB. Click OK to close the success message dialog. Click OK again to close MySQL Connection Dialog.

    Screen Shot 2012-04-26 at 7.38.17 PM.png

    10. You'll notice that the MySQL Connection you created will appear in the Databases tab.

    Screen Shot 2012-04-26 at 7.38.29 PM.png

     

    11. Also, You'll see that DW would've automatically created a folder called Connections in your Files tab along with a file within it that lets your site connect to your MySQL DB.

    Screen Shot 2012-04-26 at 7.38.44 PM.png

     

    Once you're done with this, you just need to save any changes you may have made to your page and close it. Your connection will remain attached to the site until you remove it.

     

    Trust this helps.

     
    |
    Mark as:

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