Re: Permissions problem

2002-07-12 Thread Gerald Clark
Since -p="" is not valid syntax, it should not work. There is no equal sign after the -p, and no space between the p and the password which needs no quotes. If you have no password leave out the -p option. Derek Fountain wrote: >Hi, > >I have a server running 3.23.41 on Redhat 7.1. The probl

Re: permissions problem

2002-02-12 Thread Paul DuBois
At 22:25 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Hi all, >I'm having a spot of bother with permissions (i think) >I just set up MySQL for private developement at home with PHP and >created a db 'mydb' and granted all privs to nick@localhost > >Now, I can

Re: permissions problem

2002-02-12 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared > Note that the message doesn't include a user name in front of the '@'. > > Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user,

Re: permissions problem

2002-02-12 Thread Paul DuBois
At 23:31 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > > >* and then Paul DuBois declared >> Note that the message doesn't include a user name in front of the '@'. >> >> Which it would if you were specifying one. > >Hello Paul, > I did notice that but

Re: permissions problem

2002-02-12 Thread Paul DuBois
At 0:19 +0100 2/10/02, Nick Wilson wrote: >* and then Paul DuBois declared >> >BTW >> >er... I have your book here :) >> >> Ah. Well, in *that* case, check p429 and pp464-465. You may be getting >> bit by the phenomenon described there. >sql > >Aha! Well that certainly appears to be it b

Re: permissions problem

2002-02-12 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared > Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' > table, and have you deleted the entries for user='' and run FLUSH > PRIVILEGES? Certainly have. - --

Re: permissions problem

2002-02-12 Thread Nick Wilson
* and then Paul DuBois declared > >BTW > >er... I have your book here :) > > Ah. Well, in *that* case, check p429 and pp464-465. You may be getting > bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@local

Re: permissions problem

2002-02-09 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared > Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' > table, and have you deleted the entries for user='' and run FLUSH > PRIVILEGES? Certainly have. - --

Re: permissions problem

2002-02-09 Thread Paul DuBois
At 0:19 +0100 2/10/02, Nick Wilson wrote: >* and then Paul DuBois declared >> >BTW >> >er... I have your book here :) >> >> Ah. Well, in *that* case, check p429 and pp464-465. You may be getting >> bit by the phenomenon described there. >sql > >Aha! Well that certainly appears to be it b

Re: permissions problem

2002-02-09 Thread Nick Wilson
* and then Paul DuBois declared > >BTW > >er... I have your book here :) > > Ah. Well, in *that* case, check p429 and pp464-465. You may be getting > bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@local

Re: permissions problem

2002-02-09 Thread Paul DuBois
At 22:25 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Hi all, >I'm having a spot of bother with permissions (i think) >I just set up MySQL for private developement at home with PHP and >created a db 'mydb' and granted all privs to nick@localhost > >Now, I can

Re: permissions problem

2002-02-09 Thread Paul DuBois
At 23:31 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > > >* and then Paul DuBois declared >> Note that the message doesn't include a user name in front of the '@'. >> >> Which it would if you were specifying one. > >Hello Paul, > I did notice that but

Re: permissions problem

2002-02-09 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared > Note that the message doesn't include a user name in front of the '@'. > > Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user,