4 Replies Latest reply: Apr 26, 2012 7:52 AM by sudarshan.t RSS

    MySQL Not Saving

    Daniel-Waddon

      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

        • 1. Re: MySQL Not Saving
          sudarshan.t Community Member

          Can you elaborate more on your issue please?

          • 2. Re: MySQL Not Saving
            Daniel-Waddon

            Like what? i have enterd all the information dreamweaver is not saving the connect and dont even great the connection folder

            • 3. Re: MySQL Not Saving
              Daniel-Waddon

              Anyone? i have uninstalled my dreamweaver and re tested and its still not saving the connect or makeing the Connection folder?

              • 4. Re: MySQL Not Saving
                sudarshan.t Community Member

                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.