NYCPHP Meetup

[Patrick Ramsden]

Check out http://dev.mysql.com/doc/mysql/en/access-denied.html.  There's a
bullet point mid-way down and a user comment that could be helpful.

Henry, can you post the error you're getting again and all the user name /
host combinations from the user table?

-Pat

> -----Original Message-----
> From: talk-bounces at lists.nyphp.org 
> [mailto:talk-bounces at lists.nyphp.org] On Behalf Of David Mintz
> Sent: Wednesday, July 13, 2005 1:38 PM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] different sites, one database
> 
> 
> Actually I will be joining Henry in waiting with bated breathe for the
> answer to a question similar to this one. I have gotten what 
> I thought was
> screwy behavior when there were rows in mysql.user that had 
> the same value
> for user but different values for host. Connection from one host would
> work but not the other, as thought the first matching row 
> mysql encounters
> were overshadowing the second.
> 
> Can you or can you not have two users 'foo', one of which has 
> host 'host1'
> and the other of which has 'host2' and have both be able to 
> connect from
> their respective hosts? (And I am talking about doing this 
> through GRANT
> statements rather than updating the user table directly).
> 
> 
> On Wed, 13 Jul 2005, Henry Ponce wrote:
> 
> >  [...]
> > But I can't connect from any other site to chess.ac. I 
> checked user table in
> > mysql database and there is a row that has:
> >
> > Host: 127.0.0.1
> > User: chess_ac
> >
> > This will not let me connect to chess.ac from another site 
> right? no other
> > sites have this. Can i delete that row, without affecting 
> database access?
> >
> > There is another row:
> > Host: localhost
> > User: chess_ac
> >
> > I should leave only that?
> 
> ---
> David Mintz
> http://davidmintz.org/
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
>