Connect to MySQL using local testing server on OS X

[Steve Lawrie]

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?

[hypamw]

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.

[Alexandro Colorado]

On Fri, 25 Mar 2005 08:59:46 +0000 (UTC), Steve Lawrie
<webforumsuser@macromedia.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

[Steve Lawrie]

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]

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.