Professional Web Applications Themes

Connect to MySQL using local testing server on OS X - Dreamweaver AppDev

Hello, It has taken me ages to get mysql on my Mac. I created the database I needed, (that was the easy part), and opened Dreamweaver, ready to connect. Firstly Dreamweaver suggested that I needed to upgrade MySQL because it didn't support authentication. (It's the latest version for OS X 1.2.8/Jaguar). Then I did some searching and found a solution on "Tech Notes for Dreamweaver" at: [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_16[/url] 575&extid=tn_16575&dialogID=5263476&iterationID=1& sessionID=9630d0ec656f43523050 &stateID=0%200%205269453&mode=advanced#userAcco unt I started a new user account for mysql and now I get an undentified error message that suggests that there is no testing server or that it doesn't map ...

  1. #1

    Default Connect to MySQL using local testing server on OS X

    Hello,

    It has taken me ages to get mysql on my Mac. I created the database I needed,
    (that was the easy part), and opened Dreamweaver, ready to connect.

    Firstly Dreamweaver suggested that I needed to upgrade MySQL because it didn't
    support authentication. (It's the latest version for OS X 1.2.8/Jaguar). Then I
    did some searching and found a solution on "Tech Notes for Dreamweaver" at:


    [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_16[/url]
    575&extid=tn_16575&dialogID=5263476&iterationID=1& sessionID=9630d0ec656f43523050
    &stateID=0%200%205269453&mode=advanced#userAcco unt

    I started a new user account for mysql and now I get an undentified error
    message that suggests that there is no testing server or that it doesn't map to
    a HUGE url.

    There must be a way out of this, please does anyone have a suggestion?

    Steve Lawrie Guest

  2. #2

    Default Re: Connect to MySQL using local testing server on OS X

    Are you creating a dynamic page? If so, you need to set up a testing server.
    And the following links have instruction on setting up a testing server.

    [url]http://www.macromedia.com/devnet/mx/dreamweaver/articles/php_macintosh.html[/url]
    [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16575#siteDef[/url]

    If not, you don't need a testing server. When you set up a sit (Sites >
    Manage site), you need to select the "Basic" tab and follow the instructions.

    Hope it can you a bit. I'm new to DW and just completed the tutorial with
    some help on the forum.

    hypamw Guest

  3. #3

    Default Re: Connect to MySQL using local testing server on OS X

    On Fri, 25 Mar 2005 08:59:46 +0000 (UTC), Steve Lawrie
    <webforumsusermacromedia.com> wrote:
    > Hello,
    >
    > It has taken me ages to get mysql on my Mac. I created the database I
    > needed,
    > (that was the easy part), and opened Dreamweaver, ready to connect.
    >
    > Firstly Dreamweaver suggested that I needed to upgrade MySQL because it
    > didn't
    > support authentication. (It's the latest version for OS X 1.2.8/Jaguar).
    > Then I
    > did some searching and found a solution on "Tech Notes for Dreamweaver"
    > at:
    >
    > [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_16[/url]
    > 575&extid=tn_16575&dialogID=5263476&iterationID=1& sessionID=9630d0ec656f43523050
    > &stateID=0%200%205269453&mode=advanced#userAcco unt
    >
    > I started a new user account for mysql and now I get an undentified
    > error
    > message that suggests that there is no testing server or that it doesn't
    > map to
    > a HUGE url.
    >
    > There must be a way out of this, please does anyone have a suggestion?
    >
    I suggest checking XAMPP project which is a global installer of MySQL, PHP
    and Apache on the machine. However your error might be because there is a
    Mac Bug on database connectivity.

    Also before all this, make sure you are pointing to the right URL under
    the Site definition > Testing Server > URL Prefix.

    --
    Alexandro Colorado
    ------------------------------
    Support Engineer
    InterAKT Online
    [url]http://www.interaktonline.com[/url]
    Tel: 40(21) 312.5312
    Alexandro Colorado Guest

  4. #4

    Default Re: Connect to MySQL using local testing server on OS X

    Thanks hypamw,

    for your reply.

    Yes the page is dynamic, this page
    ([url]http://www.macromedia.com/devnet/mx/dreamweaver/articles/php_macintosh.html[/url])
    I have already been to and completed the tasks. It made a change but only to
    the point where I get an error message.

    The next one,
    ([url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16575#siteDef[/url])
    is for configuring PHP which is already working on my machine.

    But thanks for your input, I am pleased that I can get a response on in this
    forum.

    Regards,

    Steve





    Steve Lawrie Guest

  5. #5

    Default Re: Connect to MySQL using local testing server on OS X

    Hello Alexandro Colorado,

    Thank you for answering my question. You are correct, the url was incorrect on
    the "Testing Server". There was also a problem with the password encryption
    being 32 bit, it had to be reduced to 16.

    Thanks again.

    Steve Lawrie Guest

Similar Threads

  1. Local server for testing
    By Roland in forum ASP Components
    Replies: 1
    Last Post: April 15th, 09:52 AM
  2. Replies: 3
    Last Post: March 29th, 02:45 AM
  3. Replies: 0
    Last Post: January 29th, 02:03 PM
  4. Replies: 1
    Last Post: January 27th, 02:49 AM
  5. Replies: 0
    Last Post: January 24th, 10:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139