[Zope] Problem on connect to MySQL

[Petter Enholm]

Correction - Too early in the morning, sorry for the inconvenience ....

> In mySQL i set up the user password like this:-
> INSERT INTO user
>
VALUES('localhost','password',PASSWORD=Password('pass52696'),'Y','Y','Y',Y',
> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
> and my Database name is CustomerDb
>

You have named the user password, hence your connection string should be:

CustomerDb password pass52696

Just for the record, I'm sure you figured this out by yourself.

Best regards

Petter Enholm

----- Original Message -----
From: "Petter Enholm" <petter@enholm.com>
To: "Angietel" <angietel@hotmail.com>
Cc: <zope@zope.org>
Sent: Tuesday, December 12, 2000 9:23 AM
Subject: Re: [Zope] Problem on connect to MySQL


> Hi,
>
> The connection string is written like this;
>
> database@host user password
>
> hence you should give the following connection string:
>
> customerDb localhost pass52696
>
> You do not need to specify the host name when running Zope and SQL-server
on
> the same machine.
> Also note that you should not use brackets (  [ ]  )  when specifying the
> host name, if you intend to do so.
>
> Best regards
>
> Petter Enholm
> Snapper as
>