[Zope] MySQL connection woes

[paul_s_johnson@urscorp.com]

After following several howtos, tracking numerous threads from this list,
and spending several days losing my mind, I sense that I am finally getting
closer to having Zope and MySQL talking to each other.

SETUP:
I am running on Linux with Redhat with MySQL 3.22.32 and ZMySQLDA with
ZMySQL-python.  The later two are installed such that ZMySQLDA is NOT
broken. I installed using the RPMs supplied by Ron Bickers available on his
FTP site (thanks, Ron) and followed additional instructions supplied on
earlier threads.

PROBLEM:
My problem now is I can't find a connection string that works. I understand
the connection syntax and tried every possibility. My suspicion is that I
am having a permissions problem with MySQL. I found this former list email:

>> My suggestion would be to set up mysql to accept a null login (no
>> username, no password), create a database in there called "test" and
>> connect with the connection string "test@localhost"

>thank u, this was the point to my problem. I have tried a nologin mysql
and it
>worked with database@myhost !!! :)
>so i know i have a grant table problem in mysql (no big deal - i hope :) )

QUESTION:
Being a relative newbie to this whole thing (Linux, Zope, MySQL, etc.), how
do I create a null login in MySQL with blanket privleges? Could it still be
a faulty ZMySQLDA setup? How do I troubleshoot that possibility?

Thanks,

P. Johnson