[Zope] Problem on connect to MySQL

[Eric Walstad]

Hello Angie,

Are you able to create a "Z MySQL Database Connection" inside Zope?
I'm not sure exactly when you are receiving your error message.  Is it when
you Click the "Change" button while in the "Z MySQL Database Connection?"

Your connection string looks like it is missing a user name.  It should look
something like (assuming your MySQL user name is "angie"):
customerDb@localhost angie pass52696
or in general terms
database@host user passwd

Generally when you see square brackets [ ] in documentation, the enclosed
code is optional.  In the case of the connection string, the host name is
optional.
However, in my setup, I have to include the host name or my connection to
the database will fail.

Hope that helps.

Eric.

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Angietel
Sent: Monday, December 11, 2000 7:37 PM
To: zope@zope.org
Subject: [Zope] Problem on connect to MySQL


When i type in the Connection String , it will prompt out the error
message - "illegal operation" and in my python it will exactly like this:-

Files\WebSite\z2.py" -D
------
2000-12-12T03:15:10 PROBLEM(100) ZServer Computing default hostname
------
2000-12-12T03:15:11 INFO(0) ZServer Medusa (V1.16.4.2) started at Tue Dec 12
11:
15:11 2000
        Hostname: ANGIE
        Port:8080

------
2000-12-12T03:15:11 INFO(0) ZServer FTP server started at Tue Dec 12
11:15:11 20
00
        Authorizer:None
        Hostname: angie
        Port: 8021
------
2000-12-12T03:15:11 INFO(0) ZServer PCGI Server started at Tue Dec 12
11:15:11 2
000
        Inet socket port: 8090
------
2000-12-12T03:15:11 INFO(0) ZServer Monitor Server (V1.8) started on port
8099

C:\Program Files\WebSite>  #// This is error msg

and i would like to confirm to u whether the Connection String is write like
this:-
customerDb[@localhost]Password pass52696


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

P/s let me know where is my mistake! Thank You!