[Zope] MySQL connection woes

[Luciano Ramalho]

I don't know how to create a null login in MySQL, but I know a better
solution. The last time I had a problem like yours I created a user in
MySQL and used it connect Zope.

In mysql you type:

GRANT ALL ON my_database.* TO my_user IDENTIFIED BY my_passwd

(The .* part is a wildcard meaning all tables in this database.)

Then you can connect Zope using a connection string like this:

my_user@localhost my_passwd

Good luck,

Luciano

PS. 


paul_s_johnson@urscorp.com wrote:
> 
> 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
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )